Re: Weird constraint output
От | Christopher Kings-Lynne |
---|---|
Тема | Re: Weird constraint output |
Дата | |
Msg-id | 07a201c36dd0$06ddf320$2800a8c0@mars обсуждение исходный текст |
Ответ на | Weird constraint output (Jeroen Ruigrok/asmodai <asmodai@wxs.nl>) |
Ответы |
Re: Weird constraint output
|
Список | pgsql-hackers |
> 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
В списке pgsql-hackers по дате отправления: