Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql and scripting [SOLVED] - Mailing list pgsql-general

From Jerome Lyles
Subject Re: Postgresql and scripting [SOLVED]
Date
Msg-id 200409080854.04372.susemail@hawaii.rr.com
Whole thread Raw
In response to Postgresql and scripting  (Jerome Lyles <susemail@hawaii.rr.com>)
Responses Re: Postgresql and scripting [SOLVED]  (Devrim GUNDUZ <devrim@gunduz.org>)
Re: Postgresql and scripting [SOLVED]  (Ben <bench@silentmedia.com>)
List pgsql-general
Tree view 
On Wednesday 08 September 2004 02:44 am, tsarevich@gmail.com wrote:
> Use timestamp instead of datetime.
>
> Where you have "REFERENCE", use "REFERENCES"
>
Thank you tsarevich that solved it.  I'm trying to 'SELECT' out of the tables
now but I'm getting another syntax error:-)

test-# SELECT prod_name FROM Products;
ERROR:  syntax error at or near "SELECT" at character 14

What is this error?
Thanks,
Jerome

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Returning multiple values (but one row) in plpgsql
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Postgresql and scripting [SOLVED]