Thread: PG 7.1.2 table names?

PG 7.1.2 table names?

From
Roy Souther
Date:
Are table names now numbers in 7.1.2? I was running 7.0.3 and I was using the
name of the files becase it was faster to parse a list of the dir then query
the db pg_tables.


--
Roy Souther <roy@silicontao.com>

01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110
01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100


Re: PG 7.1.2 table names?

From
Bruce Momjian
Date:
> Are table names now numbers in 7.1.2? I was running 7.0.3 and I was using the

Yes.

> name of the files becase it was faster to parse a list of the dir then query
> the db pg_tables.

It was not easy to change it but it makes the system more reliable.  See
/contrib/oid2name for mapping, or pg_class.relfilenode.

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