From: | Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Setyo Nugroho <snugroho(at)gmx(dot)net> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Where is the saved database? |
Date: | 2002-11-08 10:02:35 |
Message-ID: | 1036749755.2194.121.camel@kant.mcmillan.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2002-11-08 10:08:00 | Re: Performance |
Previous Message | Erwan DUROSELLE | 2002-11-08 09:59:19 | Rp. : Performance |