2011/3/24 Andrew Hammond <andrew.george.hamm...@gmail.com>: > I'm building some partitioning support functions. I'm working on writing one > called clone_indexes_to_partition right now. The idea is to take all the > indexes applied to the parent and create a matching index on the child. Is > there existing code that generates a CREATE INDEX statement given > an indexrelid?
Yes it is : http://www.postgresql.org/docs/9.0/static/functions-info.html pg_get_indexdef(index_oid) get CREATE INDEX command for index > Andrew -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers