Re: tabs in psql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 23 Mar 2008 19:35:46 -0500
Seb <spluque(at)gmail(dot)com> wrote:

> CREATE TABLE test
> (
> id Int8,
> phenotype Varchar(510),
> genotype Varchar(510)
> );

serial_test=# CREATE TABLE test
(
id Int8,
phenotype Varchar(510),
genotype Varchar(510)
);
CREATE TABLE

I can not duplicate your problem. However when I copy and paste
directly from your email it does indeed fail watch:

serial_test=# CREATE TABLE test
serial_test-# (
serial_test(# idInt8,
serial_test(# phenotype Varchar(510),
serial_test(# genotype Varchar(510)
serial_test(# );
ERROR: syntax error at or near "Varchar"
LINE 4: phenotype Varchar(510),
^

That is a direct copy and paste from your email. Notice that there is
no space between id and Int8. Once I manually put the space in, it
worked as expected.

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH5vpJATb/zqfZUUQRAk+zAJ0WerkdEjY2eDB24OBQMRn4iyHCngCfahBs
r8zG0uQChcr11XLkZ5dtY5A=
=k3m8
-----END PGP SIGNATURE-----