Creating tables in pgadmin sql editor?

Question

I am failing in creating tables via the PGadmin III SQL editor - even if the syntax is generated by the frontend:

CREATE TABLE testtable
(
   id integer, 
   "name" character varying(100)
) 
WITH (
  OIDS = FALSE
)
;

Error message is in german, but basically says that there's supposed to be a syntax error..

FEHLER:  Syntaxfehler bei »integer«
ZEILE 3:    id integer, 
                ^

********** Fehler **********

Any ideas ?

Works fine, no problem at all. Just copy-paste the above example and try again. — Frank Heikens
– Frank Heikens, Commented Jun 18, 2010 at 21:01

Peter Tillemans · Accepted Answer · 2010-06-18 20:56:47Z

2

Works fine for me.

However I see the error is indicated at line 11. Is it possible the previous statement was not properly terminated and the interpreter chooses this point to give up?

answered Jun 18, 2010 at 20:56

Peter Tillemans

35.4k11 gold badges85 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jörg Haubrichs Over a year ago

That was a copy and paste fault ;-) But you're both right, it works after copying it in a new window. I tried to analyze the query before (and the editor is still throwing that same syntax error when analyzing). Probably it somehow got messed up in some way after analyzing.

Collectives™ on Stack Overflow

Creating tables in pgadmin sql editor?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related