Re: 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