From: | mjbjr(at)beaudesign(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: querying for specs? |
Date: | 2001-12-18 07:51:44 |
Message-ID: | 20011217235144.B15582@beaudesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 18, 2001 at 05:31:55PM +1100, Martijn van Oosterhout wrote:
> 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?
>
Good point. I have, actually, though that was sometime ago, before these
questions came to mind. I have been searching 'sql' docs as of late.
For the most part, the slash commands will give me the answers I need.
Can you get the answers I'm looking for using 'sql' commands that would work
with any "standard" sql db engine?
> > 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 your help.
--
- Martin J. Brown, Jr. -
- mjbjr(at)beaudesign(dot)com -
Public PGP Key ID: 0xB29EDDCADB184F7B keyserver: http://certserver.pgp.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Fiol Bonnín | 2001-12-18 09:07:43 | Re: getting most recent row efficiently |
Previous Message | Martijn van Oosterhout | 2001-12-18 06:31:55 | Re: querying for specs? |