list all schemas in a postgresql database using psql and SQL Query postgreSQL 15 pgAdmin 4 tutorial

Published: 03 May 2023
on channel: Tech Nursery
328
3

in this video i explain three methods to list all schemas in a postgresql database
postgreSQL 15
pgAdmin 4
SQL Query
SQL Shell(psql)
psql command

1. SELECT schema_name FROM information_schema.schemata

2. SELECT nspname FROM pg_catalog.pg_namespace;

3. \dn


information_schema
pg_catalog
pg_toast


Watch video list all schemas in a postgresql database using psql and SQL Query postgreSQL 15 pgAdmin 4 tutorial online without registration, duration hours minute second in high quality. This video was added by user Tech Nursery 03 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 328 once and liked it 3 people.