querying for specs? - Mailing list pgsql-general

From mjbjr@beaudesign.com
Subject querying for specs?
Date
Msg-id 20011217213031.A15186@beaudesign.com
Whole thread Raw
Responses Re: querying for specs?
Re: querying for specs?
List pgsql-general
I'm new to sql and to postgres.  I've spent quite a bit of time trying to
determine answers to the following questions, but have been unsuccessful.

Say you work at a small company, and the person who was db admin dies
suddenly.  How do you:

1) determine what db's postgres knows about?
2) how do you determine what tables exist, if any, in a given db?
3) how do you determine the structure/specification (not the data) of a table?

Thank you for any help you can offer.

--
                            - Martin J. Brown, Jr. -
                            - mjbjr@beaudesign.com -

  Public PGP Key ID: 0xB29EDDCADB184F7B keyserver: http://certserver.pgp.com/

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: getting most recent row efficiently
Next
From: S P Arif Sahari Wibowo
Date:
Subject: Operation on bit strings with different length