Thread: Windows default editor for psql \e
Does anyone know how to change the default editor from NOTEPAD to something link gVim? It would be nice to use an editor with a little more smarts. Regards, Richard Broersma jr.
Richard Broersma Jr wrote: > Does anyone know how to change the default editor from NOTEPAD to something link gVim? It would be > nice to use an editor with a little more smarts. Sure, see the psql manual page, but setting EDITOR is the easiest way. This works on Win32 too. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
> Sure, see the psql manual page, but setting EDITOR is the easiest way. > This works on Win32 too. c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe" Thanks Bruce, this worked like a charm! And sorry to drag this, but does anyone know the windows (xp) equivalent to: /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide variables from future use? Is still the autoexec.bat? :o) Regards, Richard Broersma Jr.
Richard Broersma Jr wrote: > > Sure, see the psql manual page, but setting EDITOR is the easiest way. > > This works on Win32 too. > > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe" > > Thanks Bruce, this worked like a charm! > > And sorry to drag this, but does anyone know the windows (xp) equivalent to: > /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide variables from future > use? Is still the autoexec.bat? :o) OK, I am freaked out that I know the answer to this, but it My Computer/Properties/Advanced/Environment Variables. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
> Richard Broersma Jr wrote: > > > Sure, see the psql manual page, but setting EDITOR is the easiest way. > > > This works on Win32 too. > > > > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe" > > > > Thanks Bruce, this worked like a charm! > > > > And sorry to drag this, but does anyone know the windows (xp) equivalent to: > > /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide variables from > future > > use? Is still the autoexec.bat? :o) > > OK, I am freaked out that I know the answer to this, but it My > Computer/Properties/Advanced/Environment Variables. :-) Thanks. Just as a side note. When I specified the path string to gvim, I had leave it without quotation. However, I need the quotations when I specified the path from the DOS prompt. Once again thanks for the help. Regards, Richard Broersma Jr.
On Tue, 2006-11-28 at 22:59 -0500, Bruce Momjian wrote:
> Richard Broersma Jr wrote:
> > > Sure, see the psql manual page, but setting EDITOR is the easiest way.
> > > This works on Win32 too.
> >
> > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe"
> >
> > Thanks Bruce, this worked like a charm!
> >
> > And sorry to drag this, but does anyone know the windows (xp) equivalent to:
> > /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide variables from future
> > use? Is still the autoexec.bat? :o)
>
> OK, I am freaked out that I know the answer to this, but it My
> Computer/Properties/Advanced/Environment Variables.
Is this something we shoudl doc?
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Joshua D. Drake wrote: > On Tue, 2006-11-28 at 22:59 -0500, Bruce Momjian wrote: > > Richard Broersma Jr wrote: > > > > Sure, see the psql manual page, but setting EDITOR is the easiest way. > > > > This works on Win32 too. > > > > > > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe" > > > > > > Thanks Bruce, this worked like a charm! > > > > > > And sorry to drag this, but does anyone know the windows (xp) equivalent to: > > > /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide variables from future > > > use? Is still the autoexec.bat? :o) > > > > OK, I am freaked out that I know the answer to this, but it My > > Computer/Properties/Advanced/Environment Variables. > > Is this something we shoudl doc? Done, and backpatched to 8.2.X. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/libpq.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/libpq.sgml,v retrieving revision 1.224 diff -c -c -r1.224 libpq.sgml *** doc/src/sgml/libpq.sgml 1 Feb 2007 00:28:17 -0000 1.224 --- doc/src/sgml/libpq.sgml 4 Feb 2007 03:53:47 -0000 *************** *** 4356,4361 **** --- 4356,4368 ---- installs too. The file's location can also be specified by the <envar>PGSYSCONFDIR</envar> environment variable. </para> + + <para> + To set environment variables on Windows, from <literal>My Computer</>, + choose <literal>View System Information</>, and from the <literal>Advanced</> + tab, choose <literal>Environment Variables</>, then add a user or system + variable. + </para> </sect1>