Re: /var/lib/postgres/data/base/?

There is a /contrib module called oid2name that does this.

> in the old days ( <= 7.0.3 ) we could tell which database and
> which table we were looking at in the filesystem...
>
> now i've got lots of
>
> # ls /var/lib/postgres/data/base/
> 1  18719  18786  18824  19544  19564  19682  26790  56992  64418
> 76436
>
> # ls /var/lib/postgres/data/base/76436/
> 1215   1255   16617  16934  17058  17103  17118  17139  17154
> 17169  17184  17201  17243  17276  78222  78288  78352  1216
> 1259   16642  16948  17074  17106  17121  17142  17157  17172
> 17187  17213  17246  17288  78241  78292  78364  1219   16567
> 16653  16960  17086  17109  17124  17145  17160  17175  17190
> 17216  17258  78187  78253  78311  PG_VERSION    1247   16579
> 16685  17033  17097  17112  17133  17148  17163  17178  17193
> 17228  17261  78206  78257  78323  pg_internal.init     1249
> 16600  16867  17045  17100  17115  17136  17151  17166  17181
> 17196  17231  17273  78218  78276  78327
>
> is there a simple way of seeing which files are which relations
> (or which databases, for that matter)?
>
> and (or) a quick way to know the data-size of a row in any
> table?
>
> --
> I'd concentrate on "living in the now" because it is fun
> and on building a better world because it is possible.
>     - Tod Steward
>
> will@serensoft.com
> http://sourceforge.net/projects/newbiedoc -- we need your brain!
> http://www.dontUthink.com/ -- your brain needs us!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

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