Re: Where are my tables physically in the fs?

select relname, relfilenode from pg_class where relname = 'pg_language';

Lincoln Yeoh wrote:

> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly