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

From Tim Penhey
Subject pgAdmin III creates dud SQL for create table
Date
Msg-id 414C69F6.6090607@penhey.net
Whole thread Raw
Responses Re: pgAdmin III creates dud SQL for create table  (Tim Penhey <tim@penhey.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tim Penhey
Date:
Subject: Re: pg_restore peculiarities
Next
From: Tim Penhey
Date:
Subject: Re: pg_restore peculiarities