View Different Schemas

[Hemapriya]

Hi,

Can anyone tell me how to view the different schemas
in a database. I have created a schema and some tables
in it. Also I have altered the search_path to add the
new schema.. but still /dt doesn't give me the new
schema and its tables.

Any help?

Thanks
Priya




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Joshua D. Drake]

Post by Hemapriya
Hi,
Can anyone tell me how to view the different schemas
in a database. I have created a schema and some tables
in it. Also I have altered the search_path to add the
new schema.. but still /dt doesn't give me the new
schema and its tables.

you can do set search_path=schema;
\d

Post by Hemapriya
Any help?
Thanks
Priya
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
message can get through to the mailing list cleanly

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - ***@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly