Re: Getting table metadata - Mailing list pgsql-general

From ntinos@aueb.gr
Subject Re: Getting table metadata
Date
Msg-id courier.41EE1A47.00001D9C@red.servers.aueb.gr
Whole thread Raw
In response to Re: Getting table metadata  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
>
> SELECT * FROM pg_attribute WHERE attrelid=<the table oid>;
>
> The problem I'm running into however, is that given a table name, there
> doesn't seem to be any way to get the table oid. Is there some function
> or query that does this?

I think a way to get the table oid is:

select oid from pg_class where relname=<table_name>

Ntinos Katsaros

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: PL/PgSQL Index Usage with Trigger Variables
Next
From: "Dann Corbit"
Date:
Subject: Re: Getting table metadata