Re: OID question - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: OID question
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DF78@snt452.corp.bcbsm.com
Whole thread Raw
In response to OID question  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general

--i just got that not seconds before i got
your email (by skulking around groups.google.com)

--thanks all!

-X

-----Original Message-----
From: Arguile [mailto:arguile@lucentstudios.com]
Sent: Tuesday, February 19, 2002 9:33 AM

> How can I find out the OID of a table name?

SELECT oid FROM pg_class WHERE relname = 'object_name';

See the documentation on system tables for more info.

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: pg_dump correct version?
Next
From: Tom Lane
Date:
Subject: Re: upgrade to 7.2 & pgdumpall