Re: CREATEDB Where ??

Thanks Tony... yes that helps explain why I am not seeing what I expected 
to see.

Right.....  If I was developing an application, say with Python and I 
needed to transport my created database and make it part of an installation 
process (create a tar ball with all needed components), do I just include 
the /usr/local/pgsql/data  directory as part of my dist ??

Pete



Tony Reina wrote:

> Peter Moscatt <pmoscatt@bigpond.net.au> wrote in message
> news:<4x9f7.126086$Xr6.689318@news-server.bigpond.net.au>...
>> 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 ??
>> 
>> Pete
> 
> Sure it does. The problem you are having is that since the
> implementation of TOAST in PG 7.1, all of the db and table names are
> represented by numbers in the physical file system
> (usr/local/pgsql/data/base). So if you tried to do an 'ls' or 'find'
> for the name of your database, it probably wouldn't show up. However,
> just do a 'psql {db_name}' (where {db_name} is the name of your
> database) and you'll see that everything is kosher.
> 
> To translate the oid numbers to their respective names, use the
> oid2name function found in the /contrib under your Postgres source
> code.
> 
> -Tony
>