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

Re: finding file names

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Srinivasa Rao Chava <s(dot)chava(at)wcom(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: finding file names
Date: 2002-01-17 01:50:00
Message-ID: 20020116174931.Q48091-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 16 Jan 2002, Srinivasa Rao Chava wrote:

> In Postgresql the data file are created and named in numeric format,
> instead of text format.
> I would like move some of big tables' files to another disk. But how
> to find out which file belong to which table.
> How to map the numeric files to its respective  database objects?
> Thanks in advance for any help.

See contrib/oid2name


In response to

pgsql-admin by date

Next:From: Jean-Michel POUREDate: 2002-01-17 09:06:41
Subject: CREATE OR REPLACE VIEW / TRIGGER
Previous:From: Srinivasa Rao ChavaDate: 2002-01-16 23:15:24
Subject: finding file names

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