Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
You can use the following commands to create tables in PostgreSQL Databases and to list all the tables in the database.
CREATE TABLE
|
1 |
create table testtable(column1 int); |
LIST TABLES
|
1 |
\dt *.* |
if you list for specific schema you can use the below command.
|
1 |
\dt public.* |
