This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a command of PSQL for getting the list of Schemas of a database in PostgreSQL.
PSQL is a handy tool for PostgreSQL DBAs and they are always preferring to use a command line tool.
This article is for PostgreSQL beginner who is looking for the list of Schemas in PostgreSQL.
How to connect the database in PSQL?
1 |
-psql>\connect database_name |
Get the list of schemas:
1 |
-psql> \dn |
Get the list of databases:
1 2 3 |
-psql> \list or -psql> \l |
Leave a Reply