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

PostgreSQL DOMAIN Data Type -2

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

Postgres Database Patch

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

PostgreSQL Database startup / shutdown /restart