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