Thread: How do I see all databases and tables??
How do I see a list of all my databases.. and a list of all my tables... also does anybody know when postgresql is going to support dropping columns?? Travis
On Sat, 9 Jun 2001, Williams, Travis L, NPONS wrote: > How do I see a list of all my databases.. and a list of all my tables... This is with the so-called back-slash commands. Type "\?" in psql to get a list of available commands. regards, le -- Lukas Ertl eMail: l.ertl@univie.ac.at WWW-Redaktion Tel.: (+43 1) 4277-14073 Zentraler Informatikdienst (ZID) Fax.: (+43 1) 4277-9140 der Universität Wien
in psql \d to list all tables \l to list all database see http://www.ca.postgresql.org/docs/aw_pgsql_book/node143.html#SECTION002416000000000000000 for complete reference to psql commands regards Ryan At 12:33 AM 6/10/01 +0200, Lukas Ertl wrote: >On Sat, 9 Jun 2001, Williams, Travis L, NPONS wrote: > > > How do I see a list of all my databases.. and a list of all my tables... > >This is with the so-called back-slash commands. Type "\?" in psql to get a >list of available commands. > >regards, >le > >-- >Lukas Ertl eMail: l.ertl@univie.ac.at >WWW-Redaktion Tel.: (+43 1) 4277-14073 >Zentraler Informatikdienst (ZID) Fax.: (+43 1) 4277-9140 >der Universität Wien > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)