Postgres Pro
Downloads
Home   >   mailing lists

Thread: access to non public schema

access to non public schema

From
donghe@caltech.edu
Date:
Hello,

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

Thanks

Dong

Re: access to non public schema

From
"Kevin Grittner"
Date:
<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

Re: access to non public schema

From
donghe@caltech.edu
Date:
Thank you!
one more question, how can I know if one database has several schema?

> <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
>

Re: access to non public schema

From
"Kevin Grittner"
Date:
<donghe@caltech.edu> wrote:

> how can I know if one database has several schema?

\dn

You can get a list of available commands and options with:

\?

-Kevin

Re: access to non public schema

From
Scott Marlowe
Date:
On Wed, Jun 16, 2010 at 2:43 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> <donghe@caltech.edu> wrote:
>
>> how can I know if one database has several schema?
>
> \dn

And if you need to see the SQL running behind the scenes, start psql
with the -E switch

Re: access to non public schema

From
Dimitri Fontaine
Date:
Scott Marlowe <scott.marlowe@gmail.com> writes:
>> \dn
>
> And if you need to see the SQL running behind the scenes, start psql
> with the -E switch

Or use \set ECHO_HIDDEN, which is a toggle.
--
dim