PostgreSQL Gotchas

From PostgreSQL wiki

Revision as of 18:21, 18 May 2012 by Boshomi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Listing objects in schemas not in the search path

If you have a table in a schema named my_schema, you cannot see it using \dt unless you type:

\dt *.*

to list all tables in all schemas, or

\dt my_schema.*

to list all tables in a my_schema.

To include the schema in the search path, type:

SET search_path TO my_schema,public;

Personal tools