The numbers are not match in 7.1.2

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: The numbers are not match in 7.1.2
Date: 2001-08-07 18:17:50
Message-ID: 3B7030CE.A50C4214@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

When I do

select * from pg_database;

I got

datname | ........... | datlastsysoid
------------------------------------
mydbname | ........... | 18539

But When I

cd $PGDATA/data/base/
ls -la

I got
1
18719
18725

Where is 18539 ??!!

I think mydbname is 18725
When I

cd 18725
ls

There are a lot of numbers. How do I figure out which number is which
table_name?

BTW, what is/are the advantage(s) used the numbers instead real text
name like
7.0.x used to do?

--Raymond

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Kowalski 2001-08-07 18:18:29 Re: Admin tool
Previous Message Brent R. Matzelle 2001-08-07 18:03:35 Re: Admin tool

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-08-07 18:29:56 Re: Why can't I .........
Previous Message Bruce Momjian 2001-08-07 18:16:24 Re: Re: Fuzzy matching