Re: /var/lib/postgres/data/base/<oid>?

From: newsreader(at)mediaone(dot)net
To: will trillich <will(at)serensoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: /var/lib/postgres/data/base/<oid>?
Date: 2001-07-25 05:34:50
Message-ID: 20010725013450.A28744@dragon.universe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Morgan Curley 2001-07-25 07:11:48 Inserts in triggers
Previous Message will trillich 2001-07-25 05:19:59 /var/lib/postgres/data/base/<oid>?