Re: suggestions for tracking down syntax errors? - Mailing list pgsql-general

From Francois Suter
Subject Re: suggestions for tracking down syntax errors?
Date
Msg-id 45825990-FA54-11D7-BEB5-000393427520@monpetitcoin.com
Whole thread Raw
In response to suggestions for tracking down syntax errors?  (Terrence Brannon <metaperl@urth.org>)
List pgsql-general
> CREATE TABLE country (
>    country_id VARCHAR(3) PRIMARY KEY,
>
>    country VARCHAR(80),
> );

You have a trailing comma after VARCHAR(80) just before the closing
bracket.

As for suggestions, you could try to collapse your whole file into a
single line and check it out in a text editor by going to column number
91.

HTH

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco


pgsql-general by date:

Previous
From: david_shadovitz@xontech.com (David Shadovitz)
Date:
Subject: Procedure for adding a column
Next
From: Christopher Browne
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)