Tablespace OID, database OID, relfilenode - Mailing list pgsql-general

From Wiwwo Staff
Subject Tablespace OID, database OID, relfilenode
Date
Msg-id CAFe70G57o3OnGhDLLU6LG=eg8r5CapK9UmCcT93kvOi+7LFrGA@mail.gmail.com
Whole thread Raw
Responses Re: Tablespace OID, database OID, relfilenode  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi!
Quick and to the point:

If i execute
select pg_relation_filepath('pgbench_accounts');

I get
 pg_relation_filepath
----------------------
 base/5/16398

where "base" is tablespace, but not tablespace OID, nor tablespace name.
How do I link it to get from "base" the tablespace OID?

Or, in other words, given table  pgbench_accounts, how do I get tablespace OID, database OID and relfilenode so that I can use this info to filter output of pg_waldump?

Thanks a ton!

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Next
From: Laurenz Albe
Date:
Subject: Re: Tablespace OID, database OID, relfilenode