While there still might be a pg_dump option to do this.I have changed psql to use pg_get_viewdef(oid, true). I agree with Tom for not using it in dumps just yet though.
Is there a function for getting nice constraint defs?Of course there is, use pg_get_constraintdef(text, bool) for this.
pg_get_constraintdef(text, bool)
pg_get_expr(text, oid, bool)
pg_get_indexdef(text, int4, bool)
pg_get_ruledef(text, bool)
pg_get_viewdef(text, bool)
all have the pretty-print bool. Note that pg_get_indexdef's second parameter selects if the complete definition is returned (=0) or only that column's definition.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
