A
Anthony A

Posted on 25th February 2024|18 views

0
votes

Postgres Show Schemas

Show how to list the Schemas in PostgreSQL?

Answers
P
Anusha V

Posted on 25th February 2024

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;

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos