Re: how to edit a function from psql?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: Patrick Hatcher <PHatcher(at)macys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: how to edit a function from psql?
Date: 2004-11-04 21:40:30
Message-ID: 20041104214029.GA6872@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 04, 2004 at 02:22:06PM -0600, Thomas F.O'Connell wrote:
> To the best of my knowledge, this is not possible in psql.
>
> You can edit individual queries with \e, but I don't think it's
> possible to edit functions.

It is of course possible get the definition using \df+ and then use
CREATE OR REPLACE in conjuntion with \e to edit it at will.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Tulio: oh, para qué servirá este boton, Juan Carlos?
Policarpo: No, aléjense, no toquen la consola!
Juan Carlos: Lo apretaré una y otra vez.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-11-04 22:00:10 Re: how to edit a function from psql?
Previous Message Patrick Hatcher 2004-11-04 21:32:06 Re: how to edit a function from psql?