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

Опубликовано: 03 Октябрь 2024
на канале: 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