Re: /var/lib/postgres/data/base/<oid>?

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(at)serensoft(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

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