Re: OID question

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: "'Arguile'" <arguile(at)lucentstudios(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: OID question
Date: 2002-02-19 14:38:24
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DF78@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lucentstudios(dot)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.

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Tuinman 2002-02-19 14:39:31 Time difference changed in 7.2
Previous Message Eric Veldhuyzen 2002-02-19 14:36:00 Re: execute permissions of stored procedures?