How To Create a Table and List All Tables On PostgreSQL

dbtut

7 years ago

You can use the following commands to create tables in PostgreSQL Databases and to list all the tables in the database.

create table testtable(column1 int);

1	create table testtable(column1 int);

\dt *.*

\dt *.*

if you list for specific schema you can use the below command.

\dt public.*

1	\dt public.*