| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Boulat Khakimov <boulat(at)inet-interactif(dot)com> |
| Cc: | mpm(at)norwottuck(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Getting lengths of variable fields |
| Date: | 2001-03-06 01:15:37 |
| Message-ID: | Pine.BSF.4.21.0103051712100.65151-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 5 Mar 2001, Boulat Khakimov wrote:
> Michelle Murrain wrote:
> >
> > On Monday 05 March 2001 07:05 pm, Tom Lane wrote:
> > > Join attrelid against the OID column of pg_class ...
> >
> > Um, which column? When I look at that table, I see the following columns...
> >
> > relname | reltype | relowner | relam | relpages | reltuples |
> > rellongrelid | relhasindex | relisshared | relkind | relnatts | relchecks |
> > reltriggers | relukeys | relfkeys | relrefs | relhaspkey | relhasrules |
> > relacl
> >
>
> Yup, indeed there is no such field in pg_class.
Figure I can field this one in hopes of giving Tom more time for other
things :)
It's a system column, so it doesn't show up in the
column list that you see from a select * query, but if you do a
select oid from pg_class; you'll get it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-03-06 01:24:25 | Re: Getting lengths of variable fields |
| Previous Message | Bruce Momjian | 2001-03-06 01:04:30 | Re: List of all system tables. |