Re: [GENERAL] Table name from directory

2010-01-15 Thread Scott Marlowe
On Fri, Jan 15, 2010 at 7:59 AM, Jason Armstrong 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. -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [GENERAL] Table name from directory

2010-01-15 Thread Tom Lane
Jason Armstrong writes: > How do I get the name of a database from a directory on disk (eg > $datadir/base/16494)? That number should match the pg_database.oid column. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

[GENERAL] Table name from directory

2010-01-15 Thread Jason Armstrong
How do I get the name of a database from a directory on disk (eg $datadir/base/16494)? -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general