To create table in PostgreSQL “CREATE TABLE” command is used :
SYNTAX:
CREATE TABLE table_name( column1 datatype, column2 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );
Create table command creates tables in public schema by default
EX : Create two tables (student & mentor)
create table student (id integer primary key, name character varying(25) , age integer , gender character(1) );
CREATE table mentor ( m_id integer , name character varying(25) , subject character varying(25), primary key(m_id) );