Ask a Question

PostgreSQL - How can I list all schema in a database

+3 votes
in Databases by (60.0k points)
Is there any way to see all the schema in a database using command line? I don't want to use SQL for it.

1 Answer

+1 vote
by (354k points)
selected by
 
Best answer

Use command '\dn' on the command line and it will show the list of schemas.

database=> \dn
                 List of schemas
                Name                 |   Owner
-------------------------------------+-----------

Related questions

+2 votes
1 answer
How to connect to a database in PostgreSQL
asked Aug 14, 2019 in Databases by pythonuser (77.0k points)
+3 votes
1 answer
How to check the list of databases in PostgreSQL
asked Feb 1, 2016 in Databases by praveen (72.0k points)

Categories

Powered by Question2Answer
...