logo-MindMajix
A
Anthony A

Posted on 23rd June 2024|25 views

0
votes

Postgres Show Schemas

Show how to list the Schemas in PostgreSQL?

1 answers
Answers
P
Anusha V

Posted on 23rd June 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;

 

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
Name
Course *
Email *
Phone Number