Re: pg_attribute file in PostgreSQL 9.0 - Mailing list pgsql-admin

From Steve Crawford
Subject Re: pg_attribute file in PostgreSQL 9.0
Date
Msg-id 4F577217.3080204@pinpointresearch.com
Whole thread Raw
In response to pg_attribute file in PostgreSQL 9.0  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Responses Re: pg_attribute file in PostgreSQL 9.0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On 03/07/2012 05:14 AM, Lukasz Brodziak wrote:
> Hello,
>
> I have a question regarding pg_attribute. In which file it is stored
> because the relfilenode for it shows 0 and file 1249 isn't present in
> the folder.
>
select pg_relation_filepath('pg_attribute');

 From the docs, relfilenode is:
"Name of the on-disk file of this relation; zero means this is a
"mapped" relation whose disk file name is determined by low-level state"

However the meaning "mapped relation" and "low-level state" are
difficult to divine from the docs. Go with the function.

Cheers,
Steve


pgsql-admin by date:

Previous
From: Lukasz Brodziak
Date:
Subject: pg_attribute file in PostgreSQL 9.0
Next
From: Tom Lane
Date:
Subject: Re: pg_attribute file in PostgreSQL 9.0