Re: Postgresql and scripting [SOLVED]

From: Jerome Lyles <susemail(at)hawaii(dot)rr(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql and scripting [SOLVED]
Date: 2004-09-08 18:54:04
Message-ID: 200409080854.04372.susemail@hawaii.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 08 September 2004 02:44 am, tsarevich(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-09-08 18:59:03 Re: Postgresql and scripting [SOLVED]
Previous Message Karl O. Pinc 2004-09-08 18:51:33 Returning multiple values (but one row) in plpgsql