Re: [GENERAL] tabs in psql

2008-03-23 Thread Tom Lane
Seb <[EMAIL PROTECTED]> writes: > But the problem still occurs with 'psql -f INPUTFILE', where tab > complete is irrelevant, so I'm confused. You sure? I can't make the example fail that way. It does fail when the example-with-tab is cut and pasted directly into a terminal window, which is exact

Re: [GENERAL] tabs in psql

2008-03-23 Thread Seb
On Sun, 23 Mar 2008 18:15:55 -0700, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: [...] > Actually that would make sense as psql supports tab complete so if the > terminal interprets a tab, it isn't going to treat it as spaces. I > would suggest changing your editor to treat tabs as 4 spaces. But

Re: [GENERAL] tabs in psql

2008-03-23 Thread Joshua D. Drake
On Sun, 23 Mar 2008 20:01:28 -0500 Seb <[EMAIL PROTECTED]> wrote: > Thanks Joshua, that is the problem I wanted to illustrate; i.e. > whenever a tab separates the field name from the data type spec, the > tab character gets swallowed and psql cannot parse correctly. So it > seems tabs are not int

Re: [GENERAL] tabs in psql

2008-03-23 Thread Seb
On Sun, 23 Mar 2008 17:48:09 -0700, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: [...] > I can not duplicate your problem. However when I copy and paste > directly from your email it does indeed fail watch: [...] > That is a direct copy and paste from your email. Notice that there is > no space

Re: [GENERAL] tabs in psql

2008-03-23 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 23 Mar 2008 19:35:46 -0500 Seb <[EMAIL PROTECTED]> wrote: > CREATE TABLE test > ( > idInt8, > phenotype Varchar(510), > genotype Varchar(510) > ); serial_test=# CREATE TABLE test ( id Int8, phenotype Varchar