what is in ../data/base ??

pierre wrote:

Hello,

I am currently using 7.1.3 on an HPUX-11.00
When I do a ls -al to look at the ../data/base directory here is what i see:

postgres>ls -al
total 52
drwx------ 7 postgres users 1024 Jan 1 18:05 .
drwx------ 5 postgres sys 1024 Jan 1 17:46 ..
drwx------ 2 postgres users 2048 Dec 17 21:40 1
drwx------ 2 postgres users 3072 Dec 31 14:56 184847
drwx------ 2 postgres users 2048 Dec 17 21:34 18719
drwx------ 2 postgres users 7168 Dec 17 22:51 58443
drwx------ 2 postgres users 10240 Jan 1 17:57 5886825
postgres>pwd
/db1240/data/base
postgres>

I don't see the name of the databases I have created !!
Idem inside a database directory. I don't see the name of the tables & index !
Only numbers !

Is it so since 7.1.3 ? It was not the case with 7.0.2 !
Any light on this ?? Have I done something wrong when installing 7.1.3 ?

See contrib/oid2name for mapping from numbers to names of databases and
tables/indexes.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Try "select oid,* from pg_database" The numeric filenames are the oid.

I don't know how to do the same for tables.

Frank

At 10:37 AM 1/1/02 -0800, pierre wrote:

Hello,

I am currently using 7.1.3 on an HPUX-11.00
When I do a ls -al to look at the ../data/base directory here is what i see:

postgres>ls -al
total 52
drwx------ 7 postgres users 1024 Jan 1 18:05 .
drwx------ 5 postgres sys 1024 Jan 1 17:46 ..
drwx------ 2 postgres users 2048 Dec 17 21:40 1
drwx------ 2 postgres users 3072 Dec 31 14:56 184847
drwx------ 2 postgres users 2048 Dec 17 21:34 18719
drwx------ 2 postgres users 7168 Dec 17 22:51 58443
drwx------ 2 postgres users 10240 Jan 1 17:57 5886825
postgres>pwd
/db1240/data/base
postgres>

I don't see the name of the databases I have created !!
Idem inside a database directory. I don't see the name of the tables &

index !

bk226157@skynet.be (pierre) writes:

I don't see the name of the databases I have created !!
Idem inside a database directory. I don't see the name of the tables & index !
Only numbers !

Yes, this was changed in 7.1 to fix a couple of potential problems.
The numbers are OIDs. You can use the 'oid2name' tool in the contrib/
directory to find out the name for a given number.

Is it so since 7.1.3 ? It was not the case with 7.0.2 !
Any light on this ?? Have I done something wrong when installing 7.1.3 ?

Nope, nothing wrong. ;)

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

You wrote:

See contrib/oid2name for mapping from numbers to names of databases and
tables/indexes.

Great !!! just what I needed too.

On a side note Bryan White of pg_check fame did not respond to my mail concerning compile failure of pg_check. Is he still around???

I still have to recover data from the crash before Xmas and my client is getting impatient.

Cheers

Tony Grant

--
tony@animaproductions.com

RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

From pgsql-general-owner@postgresql.org Wed Jan 9 04:55:32 2002

Received: from eufig1.rit.reuters.com (eufig1.rit.reuters.com [194.205.123.3])
by postgresql.org (8.11.3/8.11.4) with SMTP id g099l5B59992;
Wed, 9 Jan 2002 04:47:06 -0500 (EST)
(envelope-from Maarten.Boekhold@reuters.com)
Received: from no.name.available by eufig1.rit.reuters.com
via smtpd (for postgresql.org [64.49.215.8]) with SMTP; 9 Jan 2002 09:47:58 UT
Received: from eupig1 (unverified) by reuters.com
(Content Technologies SMTPRS 4.2.1) with ESMTP id <T58570dcd47c407b70647c@reuters.com>;
Wed, 9 Jan 2002 09:47:24 +0000
Message-ID: <T58570dcd47c407b70647c@reuters.com>
Received: from eungw2.ime.reuters.com ([10.1.4.30])
by eupig1.dtc.lon.ime.reuters.com (PMDF V5.2-32 #39917)
with ESMTP id <0GPO00ESF0IB3D@eupig1.dtc.lon.ime.reuters.com>; Wed,
9 Jan 2002 09:46:59 +0000 (GMT)
Date: Wed, 09 Jan 2002 13:47:03 +0400
From: Maarten.Boekhold@reuters.com
Subject: Re: Need help
To: Jason Earl <jason.earl@simplot.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org,
pgsql-sql@postgresql.org, shamik.majumder@wipro.com
MIME-version: 1.0
X-Mailer: Lotus Notes Release 5.0.2b (Intl) 16 December 1999
Content-type: multipart/alternative; boundary="=_alternative 002E8C9A44256B3C_="
X-MIMETrack: Serialize by Router on EUNGW2/LON/GB/Reuters(Release 5.0.6a
|January 17, 2001) at 09/01/2002 09:42:08 AM,
Serialize complete at 09/01/2002 09:42:08 AM
X-Archive-Number: 200201/227
X-Sequence-Number: 19189

This is a multipart message in MIME format.
--=_alternative 002E8C9A44256B3C_=
Content-Type: text/plain; charset="us-ascii"

On 01/08/2002 09:17:03 PM Jason Earl wrote:

Why do you want a database where two tables have the same name? When
you do a "SELECT * from Table1" what table do you expect PostgreSQL to
use?

I suspect Shamik is trying to do something like having a separate 'schema'
(Oracle) for every user, and in Oracle it is possible to create tables
with the same name but in different schemas.

Maarten

----

Maarten Boekhold, maarten.boekhold@reuters.com

Reuters Consulting / TIBCO Finance Technology Inc.
Dubai Media City
Building 1, 5th Floor
PO Box 1426
Dubai, United Arab Emirates
tel:+971(0)4 3918300 ext 249
fax:+971(0)4 3918333
mob:+971(0)505526539

-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.

--=_alternative 002E8C9A44256B3C_=
Content-Type: text/html; charset="us-ascii"

<br><font size=2 face="sans-serif">On 01/08/2002 09:17:03 PM Jason Earl wrote:<br>
&gt; Why do you want a database where two tables have the same name? &nbsp;When<br>
&gt; you do a &quot;SELECT * from Table1&quot; what table do you expect PostgreSQL to<br>
&gt; use?<br>
</font>
<br><font size=2 face="sans-serif">I suspect Shamik is trying to do something like having a separate 'schema' (Oracle) for every user, and in Oracle it is possible to create tables with the same name but in different schemas.</font>
<br>
<br><font size=2 face="sans-serif">Maarten</font>
<br><font size=2 face="sans-serif"><br>
----<br>
<br>
Maarten Boekhold, maarten.boekhold@reuters.com<br>
<br>
Reuters Consulting / TIBCO Finance Technology Inc.<br>
Dubai Media City<br>
Building 1, 5th Floor<br>
PO Box 1426<br>
Dubai, United Arab Emirates<br>
tel:+971(0)4 3918300 ext 249<br>
fax:+971(0)4 3918333<br>
mob:+971(0)505526539</font><CODE><FONT SIZE=3><BR>
<BR>
-------------------------------------------------------------- --<BR>
Visit our Internet site at http://www.reuters.com&lt;BR&gt;
<BR>
Any views expressed in this message are those of the individual<BR>
sender, except where the sender specifically states them to be<BR>
the views of Reuters Ltd.<BR>
</FONT></CODE>
--=_alternative 002E8C9A44256B3C_=--

tony wrote:

You wrote:

See contrib/oid2name for mapping from numbers to names of databases and
tables/indexes.

Great !!! just what I needed too.

On a side note Bryan White of pg_check fame did not respond to
my mail concerning compile failure of pg_check. Is he still
around???

Not sure.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026