Thread: OID question

Howdy:

I'm running Postgres 7.1.3 on RedHat Linux 7.2, kernel version
2.4.7 rel-10.

This should be pretty simple- I'm trying to determine if
a few tables were dropped and recreated within a certain time.
I figured that one way to check is to see if the OID that's
mapped to a table name had changed also, the date next
to it in the database directory.

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

Thanks!

-X

-----Original Message-----
From: Stefano Reksten [mailto:sreksten@sdb.it]
Sent: Tuesday, February 19, 2002 8:05 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostgreSQL web site

Hi folks,
anyone noticed that the URL http://developer.postgresql.org/beta.php on the
website does not work properly?

Ciao,
        Stefano

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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.

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