tabs in psql

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tabs in psql
Date: 2008-03-24 00:35:46
Message-ID: 87iqzdarh9.fsf@patagonia.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm fairly new to postgresql, and I'm having some problems understanding
the syntax of SQL statements in psql. According to the documentation,
white space can be used freely. However, the following fails:

CREATE TABLE test
(
id Int8,
phenotype Varchar(510),
genotype Varchar(510)
);
testdb(> ERROR: syntax error at or near "Varchar"
LINE 4: phenotype Varchar(510),
^

where the field name and data type spec are separated by a tab
character. However, this works if the tab is separated by a single
space. Can someone please explain how this is controlled, and what the
proper syntax should be? Thanks in advance.

Cheers,

--
Seb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-03-24 00:48:09 Re: tabs in psql
Previous Message Adrian Klaver 2008-03-23 23:04:56 Re: Insert