Re: CREATEDB Where ??

Peter Moscatt <pmoscatt(at)bigpond(dot)net(dot)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.