creating a view that shows relation name -> OID

From: "Kevin T(dot) Manley" <kmanley(at)qwest(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: creating a view that shows relation name -> OID
Date: 2001-03-13 17:39:23
Message-ID: 98lm1f$5cc$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This works:

select pg_class.oid, relname from pg_class where relowner=27;

but this:

CREATE VIEW VW_FOO AS select pg_class.oid, relname from pg_class where
relowner=27;

fails with:

Attribute 'oid' has a name conflict
Name matches an existing system attribute

How come?

TIA
Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Huff 2001-03-13 18:07:28 Re: creating a view that shows relation name -> OID
Previous Message Christian Marschalek 2001-03-13 17:30:11 A thx to the List :o)