postgresql table code example

Example 1: show table postgres command

PostgreSQL show tables command
	
\dt

Example 2: postgres create table

-- Basic table creation
CREATE TABLE table_name(
   column1 datatype,
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
   PRIMARY KEY( one or more columns )
);

Example 3: show details of table postgres

postgres=# \d tablename;