Sayan Majumder
Reputation: 51
sys.schemas not avalable in postgresql
I am not being able to find an alternative for sys.schemas in postgresql. sys.schemas is available in sql server. I am new to postgres and currently migrating from sql server to postgresql. Kindly help me with this. Thanks in advance.
Upvotes: 0
Views: 739
Answers (1)
Vao Tsun
Reputation: 51406
pg_catalog.pg_namespace would be it.
Or you can use \dn metacommand in psql
Upvotes: 2
Related Questions
- Postgres 15. permission denied for schema public
- Permission denied on schema in PostgreSQL
- PostgreSQL: cannot see schemas
- PostgreSQL command does not list all schemas
- Can't access to schema in postgres
- Postgresql say “schema does not exist”
- postgres: schema does not exist when creating a table
- Why does Postgresql say "schema does not exist"
- ERROR: Schema "x" does not exist
- Postgresql query: schema does not exist