Tim Penhey wrote:
> I tried to use pgAdmin III to add a table to a database. Using the
> GUI to add the fields it ended up creating SQL like this:
>
> CREATE TABLE customer
> (
> id serial NOT NULL,
> name "varchar"(80) NOT NULL,
> balance "numeric"(10,2) NOT NULL DEFAULT 0
> )
> WITH OIDS;
>
> However it won't execute the SQL it generates, and comes back with
> "syntax error at or near "(" at character ...
> If you remove the quotes from around varchar and numeric it works fine.
>
> Tim
Forgot to mention, using Version 1.2.0 Beta 1 (Sep 8 2004)