Re: Location of databases - Mailing list pgsql-novice

From Tom Lane
Subject Re: Location of databases
Date
Msg-id 9932.1248703797@sss.pgh.pa.us
Whole thread Raw
In response to Location of databases  (john shipley <johnwshipley@hotmail.co.uk>)
Responses Re: Location of databases  (Bob McConnell <rmcconne@lightlink.com>)
List pgsql-novice
john shipley <johnwshipley@hotmail.co.uk> writes:
> I have just installed PostgreSQL, with a view to using it in conjunction with PSPP and also with OpenOffice Base.  I
havecreated a test database called exampledb with a table in it.  Where do I locate the database, please?  A file
searchfor the name reveals nothing in the filesystem, although the database and table are obviously there. 

"show data_directory" would tell you where it is ... although usually
the information is of just academic interest.

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Location of databases
Next
From: Bob McConnell
Date:
Subject: Re: Location of databases