Skip site navigation (1) Skip section navigation (2)

Re: access to non public schema

From: donghe(at)caltech(dot)edu
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: donghe(at)caltech(dot)edu, pgsql-admin(at)postgresql(dot)org
Subject: Re: access to non public schema
Date: 2010-06-16 20:41:05
Message-ID: 2431.131.215.15.78.1276720865.squirrel@webmail.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Thank you!
one more question, how can I know if one database has several schema?

> <donghe(at)caltech(dot)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
>



In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-06-16 20:43:15
Subject: Re: access to non public schema
Previous:From: Kevin GrittnerDate: 2010-06-16 19:03:38
Subject: Re: access to non public schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group