Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Postgresql ERROR: relation "pg_catalog" does not exist because pg_catalog is a schema

I couldn't find anything in the postgresql manual as how to view its
 content. SELECT does not seem to work.
       
 What's the exact command and error message?
netilla=#  \dn
        List of schemas
        Name        |  Owner
 --------------------+----------
 information_schema | postgres
 pg_catalog         | postgres
 pg_toast           | postgres
 public             | postgres
 (4 rows)

 netilla=# select * from pg_catalog;
 ERROR:  relation "pg_catalog" does not exist
     
   
That would be because pg_catalog is a schema; you can't select from it.
If you want to see what's in there, use \dS.

Comments

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Postgres Database Patch

How to Enable/Disable autovacuum on PostgreSQL

PostgreSQL Enterprise Manager - PEM Monitoring Tools