Issue with basic create statements in postgreSQL

Question

I've used the psql module to create a new database using the following syntax:

CREATE DATABASE fish

I can open the database. However, when I try to create tables or columns it gives me a syntax error for the following message.

CREATE TABLE salmon;

this is the error message:

ERROR:  syntax error at or near ";"
LINE 1: CREATE TABLE species;

I've checked a lot of online postgreSQL resources and they haven't been of much help. To the best of my knowledge, I haven't messed up the syntax. Thanks.

You need to specify columns when you create your table, or at least the primary key. — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 21, 2016 at 11:18

Saddam Khan · Accepted Answer · 2016-12-21 11:26:14Z

1

you can use this syntax for empty table:

create table salmon();

You must create atleast one column in a table:

CREATE TABLE salmon ( column_name data_type ...........);

Postgres create table link: https://www.postgresql.org/docs/9.1/static/sql-createtable.html

answered Dec 21, 2016 at 11:26

Saddam Khan

18014 bronze badges

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

Comments

Mureinik · Accepted Answer · 2016-12-21 11:23:22Z

0

You can't create an empty table - it must have at least one column. E.g.:

CREATE TABLE salmon (name VARCHAR(10));

answered Dec 21, 2016 at 11:23

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Comments

Vao Tsun · Accepted Answer · 2016-12-21 11:26:48Z

0

psql is not a module. Please read https://www.postgresql.org/docs/current/static/app-psql.html
you odn't open a database - you connect to it.

Establishes a new connection to a PostgreSQL server

https://www.postgresql.org/docs/current/static/sql-createtable.html

{ column_name | ( expression ) }

Either column list (create table a (a int);) or expression (create table b as select now() time_column) is obligatory part.

answered Dec 21, 2016 at 11:26

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Collectives™ on Stack Overflow

Issue with basic create statements in postgreSQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related