Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Thu, Mar 24, 2005 at 11:01:23PM -0300, Edson Vilhena de Carvalho wrote:
>> Can anyone tell me what is a relid, a relname and
>> schemaname data outputs resulting from the SQL: select
>> * from pg_stat_all_tables;
> relid = object ID (oid) of the relation (table)
More specifically, it's the OID of the pg_class row for the table.
So you can join the relid from that view to pg_class.oid to find
out more about the table.
> In the system catalogs "relation" doesn't always refer to a table,
> but in pg_stat_all_tables it does (pg_stat_all_tables is a view
> that shows only tables).
We really define "relation" as "anything that has a pg_class entry";
this includes tables, indexes, views, composite types, and some other
weirder cases. Some but not all of these objects have associated disk
files.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
