Re: pg_attribute file in PostgreSQL 9.0

From: Achilleas Mantzios <achill(at)smadev(dot)internal(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_attribute file in PostgreSQL 9.0
Date: 2012-03-07 13:53:05
Message-ID: 201203071553.05895.achill@smadev.internal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Τετ 07 Μαρ 2012 15:14:33 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.

in my system:

dynacom=# SELECT pg_relation_filepath('public.vessels'::regclass);
pg_relation_filepath
----------------------
base/539545/63242177
(1 row)

for system catalog tables you will have this relfilenode = 0

--
Achilleas Mantzios
IT DEPT

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2012-03-07 14:35:03 Re: pg_attribute file in PostgreSQL 9.0
Previous Message Lukasz Brodziak 2012-03-07 13:14:33 pg_attribute file in PostgreSQL 9.0