Re: Where do my local data bases go? - Mailing list pgsql-novice

On Mon, 30 Jan 2012 01:26:07 -0700
Kevin Goulding <kevingoulding@gmail.com> wrote:

>
> My question is -- how do I find where on my hard drive the newly created
> database ends up?

In Linux, files are in:
/var/lib/postgresql/Pg_version_Nb/main/base/OID_of_DB
(don't know for OSX)

This is the default path for initiating a DB.

> I have searched the names, with no luck.  Could it have
> to do with the OID number

Yep.

> (what is an "OID")?

Pg internal (integer) that represent any object (internals, tables,
columns, etc).

Pg supplies an utilitary that pairs OID and DB real name:
/usr/lib/postgresql/9.1/bin/oid2name
if you need to often use it, make a symlink into /usr/local/bin.

JY
--
    ***
  *******
 *********
 ****** Confucious say: "Is stuffy inside fortune cookie."
  *******
    ***