On Wed, 28 Sep 2011, Vincent Veyron wrote:
I'm not sure what 'INSTALL INTO ... statements' are, but are you aware of the very convenient 'M-x sql-postgres' in emacs?
Vincent, I have a SQL major mode for emacs. Don't know that it's specific to postgres but it is automatically invoked when I open a buffer with a .sql file name. I get syntax-related colors; perhaps it does more of which I am unaware.
I got it to work with this in my .emacs file (setq sql-user "yourusername") (setq sql-database "yourdbname") (setq sql-server "localhost") (setq sql-postgres-options '("-Uyourusername" "-P" "pager=off"))
I'll look for sql-postgres if it will allow me to add rows to an existing table. Many thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general