In this post, we will provide the psql command to choose a specific database and show all its tables.
Connect or switch to a specific database
\c database_name
For example, the following command connects to the "employees" database:
mydb=# \c employees
You are now connected to database "employees" as user "postgres".
employees=#Lists all tables in a current database
Command:
\dt
Example:
mydb=# \dt
List of relations
Schema | Name | Type | Owner
--------+-------+-------+----------
public | users | table | postgres
(1 row)
Comments
Post a Comment