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.
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.
The PostgreSQL CREATE TABLE statement is used to create a new table in any of the given database.