Re: Where are my tables physically in the fs?

From: Egyud Csaba <csegyud(at)freemail(dot)hu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Subject: Re: Where are my tables physically in the fs?
Date: 2002-12-14 22:53:50
Message-ID: 000001c2a3d8$7331c460$800a0a0a@xxx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)pop(dot)jaring(dot)my>
To: "Egyud Csaba" <csegyud(at)freemail(dot)hu>; "pgsql-general"
<pgsql-general(at)postgresql(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-12-14 22:58:30 Re: [GENERAL] PerformPortalClose warning in 7.3
Previous Message Reynard Hilman 2002-12-14 22:17:35 Re: index not being used