Sample postgresql database for psequel

broken image

Then, in brackets, comes the list, defining each column in the table and what sort of data type it is. Initially, the empty table in the current database is owned by the user issuing the command.

broken image

The unique name or identifier for the table follows the CREATE TABLE statement. Syntaxīasic syntax of CREATE TABLE statement is as follows −ĬREATE TABLE is a keyword, telling the database system to create a new table.

broken image

The PostgreSQL CREATE TABLE statement is used to create a new table in any of the given database.

broken image