How can I get the table schema for a database or the field schema for a table? I'm connected remotely via a socket, so I can't just dump it an inspect the result.
Even if I could just verify the existence of a table/field, that would work.
If you start psql with the -E flag then \d etc will show the queries they send.
You might also want to consider looking at the information_schema schema which provides a standardised view of database structure.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]