Postgresql Create Table If Not Exists

• First, we use the Create Table statement to create a table in the PostgreSQL.
• Now name the table_name.
• Now by providing columns with column names, type of data to be stored in columns and size of the columns in parentheses(size).
• The primary key defines a record, so it points a table or set of information.

CREATE DATABASE employee_details;

CREATE TABLE employee_data(

id INT not null,

name VARCHAR(20) unique not null,

dob DATETIME not null,

email VARCHAR(40) unique,

created_on TIMESTAMP not null,

last_login TIMESTAMP

Primary key(id)

);

Output: