Re: pgAdmin III creates dud SQL for create table - Mailing list pgsql-general

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)