Re: OID question

From: "Arguile" <arguile(at)lucentstudios(dot)com>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: OID question
Date: 2002-02-19 14:32:49
Message-ID: LLENKEMIODLDJNHBEFBOGEDFEDAA.arguile@lucentstudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shaunn Johnson wrote,

> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message BELLON Michel 2002-02-19 14:33:40 OID and 7.2 release
Previous Message Johnson, Shaunn 2002-02-19 14:09:19 OID question