Re: /var/lib/postgres/data/base/? - Mailing list pgsql-general

From newsreader@mediaone.net
Subject Re: /var/lib/postgres/data/base/?
Date
Msg-id 20010725013450.A28744@dragon.universe
Whole thread Raw
In response to /var/lib/postgres/data/base/?  (will trillich <will@serensoft.com>)
List pgsql-general
The following command should tell
you what you need.

=> select relfilenode,relname from pg_class where relname !~ '^pg';

hth


On Wed, Jul 25, 2001 at 12:19:59AM -0500, will trillich wrote:
> in the old days ( <= 7.0.3 ) we could tell which database and
>
> is there a simple way of seeing which files are which relations

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: /var/lib/postgres/data/base/?
Next
From: "Dr. Evil"
Date:
Subject: More.. Re: Changes to C interface from 7.0 to 7.1