PostgreSQL Gotchas

From PostgreSQL wiki
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;