Posted on 25th July 2024|25 views
Show how to list the Schemas in PostgreSQL?
Posted on 25th July 2024| views
In PostgreSQL, all the schemas shown and listed using the command( \dn ).
or
As PostgreSQL can be used to view all the schemas present using standard information_schema which lists all the database schemas present:
Syntax:
select schema_name
from information_schema.schemata;