pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedaccess to non public schema
6+ messages / 4 participants
[nested] [flat]
* access to non public schema
@ 2010-06-16 17:56 donghe@caltech.edu
0 siblings, 1 reply; 6+ messages in thread
From: donghe@caltech.edu @ 2010-06-16 17:56 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: access to non public schema
@ 2010-06-16 19:03 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: donghe@caltech.edu
0 siblings, 1 reply; 6+ messages in thread
From: Kevin Grittner @ 2010-06-16 19:03 UTC (permalink / raw)
To: donghe@caltech.edu; pgsql-admin
<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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: access to non public schema
@ 2010-06-16 20:41 donghe@caltech.edu
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 6+ messages in thread
From: donghe@caltech.edu @ 2010-06-16 20:41 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: donghe@caltech.edu; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: access to non public schema
@ 2010-06-16 20:43 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: donghe@caltech.edu
0 siblings, 1 reply; 6+ messages in thread
From: Kevin Grittner @ 2010-06-16 20:43 UTC (permalink / raw)
To: donghe@caltech.edu; +Cc: pgsql-admin
<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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: access to non public schema
@ 2010-06-16 20:53 Scott Marlowe <scott.marlowe@gmail.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2010-06-16 20:53 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: donghe@caltech.edu; pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: access to non public schema
@ 2010-06-17 07:45 Dimitri Fontaine <dfontaine@hi-media.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Dimitri Fontaine @ 2010-06-17 07:45 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; donghe@caltech.edu; pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-06-17 07:45 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-16 17:56 access to non public schema donghe@caltech.edu
2010-06-16 19:03 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-16 20:41 ` donghe@caltech.edu
2010-06-16 20:43 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-16 20:53 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-06-17 07:45 ` Dimitri Fontaine <dfontaine@hi-media.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox