Dave Page wrote:

Hi,



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:13
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] View column defaults in pgAdminIII


I recently installed pgAdmin III and am happy to see the great work done by the team.

Thank you very much for so great a software tool!



You're welcome, glad you like it!




a) I'd really like the view DDL to include the CRLF's that I had put for formatting convenience in the original view creation statement, rather than have the pgAdminIII just insert them at pre-defined, generically appropriate places (which looks like before each major key word of a SELECT statement). When I want to review or modify a view definition, I often end up having to navigate with the right-arrow key through the view and inserting a CRLF before each view column, for instance.



Unfortunately this is not possible because PostgreSQL doesn't retain the
original SQL entered (see the many discussions about this on the
pgsql-hackers list for details).


Yes, and I had quite some fights to get this pretty-print functions into the backend for guys like us that don't like dozens of parentheses and a view definition of 10k on a single line.

b) Include in the view definition DDL any column defaults. When I do a pg_dump -t myview... at the server console, the output includes not only the view DDL, rules, and permissions, but also column defaults. Would be nice for the sake of completeness to see the column defaults in the pgAdminIII DDL also.



I'm not sure what you mean here. Views don't have column defaults, only
the underlying relations do. How would you expect that to be expressed
in SQL (which pg_dump didn't do when I tried it btw)?



View columns are a bit... neglected at the moment. I took this on the TODO list.


Regards,
Andreas



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to