Re: Numeric file names
От | Peter Eisentraut |
---|---|
Тема | Re: Numeric file names |
Дата | |
Msg-id | Pine.LNX.4.21.0010282349150.763-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Numeric file names (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Numeric file names
Re: Numeric file names |
Список | pgsql-hackers |
Bruce Momjian writes: > Now that we have numeric file names, I would like to have a command I > can run from psql that will dump a mapping of numeric file name to table > name, i.e., > > 121233 pg_proc > 143423 pg_index select oid, relname from pg_class; > With that feature, I can write scripts pgfile2name and pgname2file that > map file names to table names. People can run standard Unix commands > and have meaningful display output: > > ls -l | pgfile2name sed `psql -Aqt -d ${database} -c "select'-e s/' || oid || '/' || relname || '/g' from pg_class"` What I'd find useful is a program that you can occasionally run on a database directory that creates links from "name" to "oid". -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-hackers по дате отправления: