postgresql 在 pgadmin sql 编辑器中创建表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3072990/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Creating tables in pgadmin sql editor?
提问by J?rg Haubrichs
I am failing in creating tables via the PGadmin III SQL editor - even if the syntax is generated by the frontend:
我无法通过 PGadmin III SQL 编辑器创建表 - 即使语法是由前端生成的：
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 ?
有任何想法吗 ？
回答by Peter Tillemans
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?
但是我看到错误显示在第 11 行。是否有可能之前的语句没有正确终止并且解释器选择放弃这一点？
