> Obviously psql uses either use pg_constraint.consrc or > pg_get_expr(conbin, conrelid) which both will give this lot of > parentheses, so it's not a bug, but a feature > For easier reengineering, I invented several pg_get_xxx functions with a > pretty-print option, which omits this messy parentheses, because I > noticed how ugly this looks while writing pgAdmin3 (especially for large > views with many joins and big expressions). > There have been suggestions to use the pretty-print options for psql (I > don't know which have been realized so far), and very harsh rejects > doing this in pg_dump, namely from Tom).
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? Chris ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
