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

The following command should tell
you what you need.

=> select relfilenode,relname from pg_class where relname !~ '^pg';

hth

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