Re: CREATEDB Where ?? - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: CREATEDB Where ??
Date
Msg-id m3snemlqoq.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to CREATEDB Where ??  (Peter Moscatt <pmoscatt@bigpond.net.au>)
List pgsql-hackers
Peter Moscatt <pmoscatt@bigpond.net.au> writes:

> I am pretty new to PostgreSQL so please bare with me  :-)
> 
> When issuing the CREATEDB MyDb  then creating some tables with CREATE 
> TABLE, I then go back and do a search for the file I have just created 
> (MyDb) but can't find the physical file.
> 
> Does one actually exist ??

Yes, they're named by OID (integer) in $PGDATA rather than by database
name.  There's a reason for this so don't complain about it.  ;)

-Doug
-- 
Free Dmitry Sklyarov! 
http://www.freesklyarov.org/ 

We will return to our regularly scheduled signature shortly.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Suggestion for To Do List - Client timeout please.
Next
From: Bruce Momjian
Date:
Subject: Re: Guide to PostgreSQL source tree