Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Steve CrawfordDate: 2012-03-07 14:35:03
Subject: Re: pg_attribute file in PostgreSQL 9.0
Previous:From: Lukasz BrodziakDate: 2012-03-07 13:14:33
Subject: pg_attribute file in PostgreSQL 9.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group