finding indexed functions from pg_index
От | Scott Cain |
---|---|
Тема | finding indexed functions from pg_index |
Дата | |
Msg-id | Pine.GSO.4.05.10509201409020.23347-100000@phage.cshl.edu обсуждение исходный текст |
Ответы |
Re: finding indexed functions from pg_index
Re: finding indexed functions from pg_index |
Список | pgsql-interfaces |
Hi, I am trying to modify SQL::Translator, a perl module for translating various dialects of SQL ddl (table, index creates, constraints, etc) (and it does other cool things too, check it out!), to talk directly to a PostgreSQL database to determine what tables it has, what columns they have, indexes, constraints, etc. I have mostly figured out what I need from pg_namespace, pg_class, pg_index and pg_attribute. What I haven't figure out is this: how does one determine what the declarative statement is for a functional index that is obtained from pg_index.indexprs? What I would like to be able to do is be able to recreate the SQL that defined that index. Is that represented somewhere in another system table? Thanks, Scott ---------------------------------------------------------------------- Scott Cain, Ph. D. cain@cshl.org GMOD Coordinator, http://www.gmod.org/ (216)392-3087 ----------------------------------------------------------------------
В списке pgsql-interfaces по дате отправления: