Thread: Where is the saved database?

Where is the saved database?

From
Setyo Nugroho
Date:
Hi all,
I am puzzeld how the file system works. Where are databases, tables,
functions etc, created using psql, stored? In which format/ extension?

Can we view these files with a normal editor such as Kate?

Regards,
Setyo Nugroho









Re: Where is the saved database?

From
Andrew McMillan
Date:
On Fri, 2002-11-08 at 22:07, Setyo Nugroho wrote:
> Hi all,
> I am puzzeld how the file system works. Where are databases, tables,
> functions etc, created using psql, stored? In which format/ extension?

Depends on your setup.  On Debian GNU/Linux it is under
/var/lib/postgres/data/base... for example.


> Can we view these files with a normal editor such as Kate?

No more than you can examine any other binary file with a normal editor
such as Kate - i.e. not _usefully_.

The manual describes the file format, and should be your first port of
call if you really want to understand it.

Cheers,
                    Andrew
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------