Re: CREATEDB Where ??

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.