| From: | mjbjr(at)beaudesign(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | querying for specs? |
| Date: | 2001-12-18 05:30:31 |
| Message-ID: | 20011217213031.A15186@beaudesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)beaudesign(dot)com -
Public PGP Key ID: 0xB29EDDCADB184F7B keyserver: http://certserver.pgp.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | S P Arif Sahari Wibowo | 2001-12-18 05:33:43 | Operation on bit strings with different length |
| Previous Message | Mike Smialek | 2001-12-17 23:27:47 | Re: case sensititvity bug in foreign keys on cygwin |