creating a view that shows relation name -> OID - Mailing list pgsql-general

From Kevin T. Manley
Subject creating a view that shows relation name -> OID
Date
Msg-id 98lm1f$5cc$1@news.tht.net
Whole thread Raw
Responses Re: creating a view that shows relation name -> OID  (Bill Huff <bhuff@colltech.com>)
Re: creating a view that shows relation name -> OID  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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






pgsql-general by date:

Previous
From: "Christian Marschalek"
Date:
Subject: A thx to the List :o)
Next
From: Bill Huff
Date:
Subject: Re: creating a view that shows relation name -> OID