Re: Quick-and-Dirty Data Entry with LibreOffice3? - Mailing list pgsql-general

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