| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "M(dot) Bastin" <marcbastin(at)mindspring(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: system tables |
| Date: | 2004-03-03 23:31:09 |
| Message-ID: | 19167.1078356669@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"M. Bastin" <marcbastin(at)mindspring(dot)com> writes:
> 1. How do I find the user name for a given pid?
See pg_stat_activity.
> 2. Where's the list that links all valid text encoding names with the
> numbers representing them? (E.g. UNICODE = 6)
I don't believe this list exists as a system catalog. It is accessible
through the pg_char_to_encoding() and pg_encoding_to_char() functions,
though.
> Is there an easy way to recoup how the different system tables are
> related to each other, or does one simply have to know?
See the docs:
http://www.postgresql.org/docs/7.4/static/catalogs.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tully | 2004-03-04 02:46:42 | Re: Column Headings using Comment? |
| Previous Message | Bruce Momjian | 2004-03-03 22:31:30 | Re: Merging multiple values into comma-delimited list in a |