Le mercredi 29 août 2012 à 09:48 -0400, Moshe Jacobson a écrit : > > > Questions: > 1. If I want the inherited table's columns indexed the same way as the > parent, must I create new indexes on the inherited table? > 2. If I move the inherited table to a new schema, will its indexes > also be moved into the new schema? > 3. Any difference in behavior regarding check constraints, schemas, > indexes, etc that I should be aware of between inherited tables > created with pure inheritance as opposed to "like <parent_table>"? >
The 'LIKE' section of the documentation for CREATE TABLE explains it : http://www.postgresql.org/docs/9.1/static/sql-createtable.html -- Vincent Veyron http://marica.fr/ Gestion informatique des sinistres d'assurances et des dossiers contentieux pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
