Re: Where are my tables physically in the fs?

Dear Link,
I'll check it. As I can see from your ansver the file/dir names are the
OIDs.
Thank you very much.

Csaba


----- Original Message -----
From: "Lincoln Yeoh" <lyeoh@pop.jaring.my>
To: "Egyud Csaba" <csegyud@freemail.hu>; "pgsql-general"
<pgsql-general@postgresql.org>
Sent: Saturday, December 14, 2002 2:38 AM
Subject: Re: [GENERAL] Where are my tables physically in the fs?


> The tables are in $PGDATA/base.
>
> For an easy way to find out what the numbers mean check out
> contrib/oid2name in the postgresql source distribution.
>
> I personally can't remember the manual way, but it involves doing selects
> on the system tables. You might be able to figure out what SQL to use by
> either checking oid2name or running psql -E and then using the \d
commands.
>
> Link.
>
> At 09:38 AM 12/14/02 -0800, Egyud Csaba wrote:
>
> >Hi!
> >
> >I konow, it is a lamer question, but the doc doesn't inculde any details
> >reguarding the physical storage of db. It is not seriously important for
me
> >just I would like to know.
> >I use pg7.2.3 on Red Hat 7.1. The provious verson I used was 7.0.3, and
it
> >was easy to find my tables in the fs. The file names told me something -
> >nearly everything. But now what I can find are only nubers and numbers
under
> >my $PGDATA/base directory.
> >
> >Once more it isn't too important. If somebody has some time please send
me a
> >url where I can find some more info.
> >
> >Thanks, and best reguards
>
>
>
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.427 / Virus Database: 240 - Release Date: 2002.12.06.