470,596 Members | 1,347 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

pgAdmin III creates dud SQL for create table

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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
1 3199
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)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Matthew T. O'Connor | last post: by
1 post views Thread by Egyd Csaba | last post: by
2 posts views Thread by raptor | last post: by
2 posts views Thread by mmd | last post: by
1 post views Thread by raptor | last post: by
reply views Thread by Laurent Duperval | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.