access to non public schema
access to non public schema
am 16.06.2010 19:56:17 von donghe
Hello,
when I use #\d, it only list tables of public schema, how can I see/acces=
s
non-public schema in a database?
Thanks
Dong
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: access to non public schema
am 16.06.2010 21:03:38 von Kevin Grittner
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: access to non public schema
am 16.06.2010 22:41:05 von donghe
Thank you!
one more question, how can I know if one database has several schema?
> 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=3D> \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
>
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: access to non public schema
am 16.06.2010 22:43:15 von Kevin Grittner
wrote:
> how can I know if one database has several schema?
\dn
You can get a list of available commands and options with:
\?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: access to non public schema
am 16.06.2010 22:53:58 von Scott Marlowe
On Wed, Jun 16, 2010 at 2:43 PM, Kevin Grittner
wrote:
> 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: access to non public schema
am 17.06.2010 09:45:05 von Dimitri Fontaine
Scott Marlowe 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin