From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | mjbjr(at)beaudesign(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: querying for specs? |
Date: | 2001-12-18 06:31:55 |
Message-ID: | 20011218173155.A12335@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Dec 17, 2001 at 09:30:31PM -0800, mjbjr(at)beaudesign(dot)com wrote:
> 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:
Question: Did you read the little help message that pops up when you start
psql?
> 1) determine what db's postgres knows about?
psql -l
> 2) how do you determine what tables exist, if any, in a given db?
\d
> 3) how do you determine the structure/specification (not the data) of a table?
\d [tablename]
You can use pg_dump -s to extract all the grotty details if oyu like.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.
From | Date | Subject | |
---|---|---|---|
Next Message | mjbjr | 2001-12-18 07:51:44 | Re: querying for specs? |
Previous Message | Stephan Szabo | 2001-12-18 06:18:30 | Re: querying for specs? |