Hi the list, I used to run oid2name to find the relation between database names and .../data/base/<dir> but i'm interested also to identify relation between table names, index names and files number as would try to decrease Wait I/O by setting tables on one disk and indexes on another one. The tables pg_class and pg_index do not give the symbolic name with the "numbers".
Thierry Missimilly. [EMAIL PROTECTED] wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > > In postgresql all databases are stored in /data/base directory in > > numbers form and all the related tables with that database are stored in > > that directory again in numbers form. > > so there is any command or query to see the original table names. > > just like:- select * from pg_stat_database; for databases. > > You can find the mapping between the "numbers" on disk and the tables by > looking at the "relfilenode", "relname" and "relkind" columns of the > pg_class table. However, it is best to not mess with those files at > all. What are you trying to do? > > - -- > Greg Sabino Mullane [EMAIL PROTECTED] > PGP Key: 0x14964AC8 200312070810 > > -----BEGIN PGP SIGNATURE----- > > iD8DBQE/0yb5vJuQZxSWSsgRAoOMAJ9FZsojXzvCVgrM6Tv0B3f+eI0k8QCg6X8C > fqQi82DmYdZduq4lwADIou0= > =92w+ > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/R&D adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;-18184 fn:Thierry Missimilly end:vcard
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
