pgAdmin III creates dud SQL for create table

From: Tim Penhey <tim(at)penhey(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pgAdmin III creates dud SQL for create table
Date: 2004-09-18 17:01:42
Message-ID: 414C69F6.6090607@penhey.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Penhey 2004-09-18 17:09:26 Re: pg_restore peculiarities
Previous Message Tim Penhey 2004-09-18 16:57:56 Re: pg_restore peculiarities