Hackers, I am in the process of fixing the oid2name contrib module. It needs a lot of care and feeding. Hopefully for the next release we can move it to src/bin/scripts so it can use the routines that are in common.c, and some of the ugliness can go.
I think it will stay in contrib for 8.0 however, so it needs to be fixed now. While I was playing with it, I noticed several shortcomings: - it only works in the PUBLIC schema - it only knows about tables and databases, except when running in "show systables" mode, and then it will show all indexes, toast tables, etc - it only displays relfilenode and tablename - there's no way to query by relfilenode, only by Oid (note that the last two means the program is somewhat inconsistent) This last one IMHO makes the program somewhat useless, because what the user normally wants to know is what table does a certain file on disk belong to, and the Oid may not provide that. I want to fix this, by providing switches to allow querying by filenode, Oid and tablename; and to show not only filenode and name, but also schema and tablespace. Is this acceptable for this release? Other opinions? -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "This is a foot just waiting to be shot" (Andrew Dunstan) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly