Обсуждение: Emacs and postgres

Поиск
Список
Период
Сортировка

Emacs and postgres

От
Sean Davis
Дата:
This is a bit off-topic....

Does anyone know of an interface between emacs and psql?  I currently
use it as my default editor and do my share of save and then \i.  I
just gave pgEdit a try and liked many aspects of it, but I still like
Emacs as an editor and wondered if anyone else has tricks/plugins for
emacs users.

Sean


Re: Emacs and postgres

От
Joe Healy
Дата:
Sean Davis wrote:

> This is a bit off-topic....
>
> Does anyone know of an interface between emacs and psql?  I currently
> use it as my default editor and do my share of save and then \i.  I
> just gave pgEdit a try and liked many aspects of it, but I still like
> Emacs as an editor and wondered if anyone else has tricks/plugins for
> emacs users.


I have used sql-postgres mode in the past, under both emacs and xemacs.
It is quite good. Haven't got it working currently under windows, I
think I need to tell it where i have a psql binary.


Joe

Re: Emacs and postgres

От
John DeSoi
Дата:
Hi Sean,

On Feb 23, 2005, at 4:19 PM, Sean Davis wrote:

> Does anyone know of an interface between emacs and psql?  I currently
> use it as my default editor and do my share of save and then \i.  I
> just gave pgEdit a try and liked many aspects of it, but I still like
> Emacs as an editor and wondered if anyone else has tricks/plugins for
> emacs users.

Thanks for trying pgEdit. I know it can't ever be emacs, but let me
know if there are some particular things in the emacs compatibility
features that add, improve, or fix.

I'm keeping a blog now if you are interested in following pgEdit design
and development.

http://pgedit.com/blog/1

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: Emacs and postgres

От
Joe Healy
Дата:
Joe Healy wrote:

> Sean Davis wrote:
>
>> This is a bit off-topic....
>>
>> Does anyone know of an interface between emacs and psql?  I currently
>> use it as my default editor and do my share of save and then \i.  I
>> just gave pgEdit a try and liked many aspects of it, but I still like
>> Emacs as an editor and wondered if anyone else has tricks/plugins for
>> emacs users.
>
>
>
> I have used sql-postgres mode in the past, under both emacs and
> xemacs. It is quite good. Haven't got it working currently under
> windows, I think I need to tell it where i have a psql binary.


I have now told emacs where my psql binary is, but I do not get the
prompt. Does anyone know how to change this?


Thanks

Joe

Re: Emacs and postgres

От
merlyn@stonehenge.com (Randal L. Schwartz)
Дата:
>>>>> "Sean" == Sean Davis <sdavis2@mail.nih.gov> writes:

Sean> Does anyone know of an interface between emacs and psql?  I currently
Sean> use it as my default editor and do my share of save and then \i.  I
Sean> just gave pgEdit a try and liked many aspects of it, but I still like
Sean> Emacs as an editor and wondered if anyone else has tricks/plugins for
Sean> emacs users.

sql-mode works fairly nice, and has a postgres submode.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

Re: Emacs and postgres

От
Greg Stark
Дата:
Sean Davis <sdavis2@mail.nih.gov> writes:

> This is a bit off-topic....
>
> Does anyone know of an interface between emacs and psql?  I currently use it as
> my default editor and do my share of save and then \i.  I just gave pgEdit a
> try and liked many aspects of it, but I still like Emacs as an editor and
> wondered if anyone else has tricks/plugins for emacs users.

You could just set EDITOR to emacsclient and run M-x server-start and use \e.

Personally I just use psql directly under something like shell-mode. That
doesn't give me completion but it gives me a history and editing.

--
greg