Postgres Pro
Downloads
Home   >   mailing lists

Re: access to non public schema - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: access to non public schema
Date
Msg-id 4C18D9BA02000025000324A2@gw.wicourts.gov
Whole thread Raw
In response to access to non public schema  (donghe@caltech.edu)
Responses Re: access to non public schema  (donghe@caltech.edu)
List pgsql-admin
Tree view 
<donghe@caltech.edu> wrote:

> when I use #\d, it only list tables of public schema, how can I
> see/access non-public schema in a database?

Include the schema on your search_path or specify it on your \d
command.  For example:

cir=> \dt information_schema.*
                      List of relations
       Schema       |          Name           | Type  | Owner
--------------------+-------------------------+-------+-------
 information_schema | sql_features            | table | ccsa
 information_schema | sql_implementation_info | table | ccsa
 information_schema | sql_languages           | table | ccsa
 information_schema | sql_packages            | table | ccsa
 information_schema | sql_parts               | table | ccsa
 information_schema | sql_sizing              | table | ccsa
 information_schema | sql_sizing_profiles     | table | ccsa
(7 rows)

-Kevin

pgsql-admin by date:

Previous
From: donghe@caltech.edu
Date:
Subject: access to non public schema
Next
From: donghe@caltech.edu
Date:
Subject: Re: access to non public schema