Re: Location of databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: john shipley <johnwshipley(at)hotmail(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Location of databases
Date: 2009-07-27 14:09:57
Message-ID: 9932.1248703797@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

john shipley <johnwshipley(at)hotmail(dot)co(dot)uk> writes:
> I have just installed PostgreSQL, with a view to using it in conjunction with PSPP and also with OpenOffice Base. I have created a test database called exampledb with a table in it. Where do I locate the database, please? A file search for 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bob McConnell 2009-07-27 20:52:04 Re: Location of databases
Previous Message Thurber, Fred 2009-07-27 13:57:33 Re: Understanding the output of EXPLAIN ANALYSE