Re: Table name from directory

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jason Armstrong <ja(at)riverdrums(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table name from directory
Date: 2010-01-15 15:42:34
Message-ID: dcc563d11001150742p1a4e4e56j4ef81e509b9f54b3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 15, 2010 at 7:59 AM, Jason Armstrong <ja(at)riverdrums(dot)com> wrote:
> How do I get the name of a database from a directory on disk (eg
> $datadir/base/16494)?

There's a handy little utility called oid2name you can use to do it
from the command line.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-01-15 15:51:12 Re: Creation of tablespaces
Previous Message Scott Marlowe 2010-01-15 15:41:38 Re: vacuum issues under load?