Doug Hall wrote:
Sorry for the newbie question, but how do you get PostgreSQL to list the
available databases? I know how to log into a certain database, but not
list all of them. I know this must be possible because the phppgAdmin
web site demonstrates it with their trial server.
Thanks,
Doug Hall
Try \? in psql, it will show some really nice commands. \d will show you the
tables, and "\d tablename" will describe the table.
Try \dS and friends to see the system tables.
One of the best ways to see what is going on under the covers to to
run psql --echo-hidden:
--echo-hidden
Echoes the actual queries generated by \d and other
backslash commands. You can use this if you wish to
include similar functionality into your own pro
grams. This is equivalent to setting the variable
ECHO_HIDDEN from within psql.
Whoever thought to add this to psql is a genius!!!
HTH...
Mark
--
Mark Harrison
Pixar Animation Studios
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
