ERROR: syntax error at or near “;” at CREATE TABLE
ERROR: syntax error at or near “;” at CREATE TABLE
I study Postgresql. I've just installed PG on Ubuntu, checkout as user "postgres" and run psql commandline. But when I try to execute commands like SHOW, CREATE and so on, I get:
ERROR: syntax error at or near ";"
postgres@comp:/etc/postgresql/10/main$ psql
psql (10.5 (Ubuntu 10.5-1.pgdg18.04+1))
Type "help" for help.
postgres=# c
You are now connected to database "postgres" as user "postgres".
postgres=# CREATE TABLE TEST1
postgres-# ;
ERROR: syntax error at or near ";"
LINE 2: ;
^
postgres=# CREATE TABLE TEST1;
ERROR: syntax error at or near ";"
LINE 1: CREATE TABLE TEST1;
^
postgres=# CREATE TABLE 'TEST1';
ERROR: syntax error at or near "'TEST1'"
LINE 1: CREATE TABLE 'TEST1';
^
postgres=#
I tried to find the same issues on Stackoverflow, but no result. What did I do wrong?
CREATE TABLE
Please see the manual for a detail description on the syntax of the
create table statement. You might want to start with the tutorial that contains many examples with the correct syntax. Add make sure you understand the difference between identifiers and strings– a_horse_with_no_name
Sep 11 '18 at 9:57
create table
0
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
I can comment on what you aren't doing. You aren't actually specifying any column names or definitions, types, etc. Try entering a valid
CREATE TABLEdefinition, and see if that works.– Tim Biegeleisen
Sep 11 '18 at 9:47