Re: Getting lengths of variable fields

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.

In response to

Responses

Browse pgsql-general by date

  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.