Re: psql: add \create_function command - Mailing list pgsql-hackers

From Adam S
Subject Re: psql: add \create_function command
Date
Msg-id CALWCfdLJESOMWoA1-3+871p2if28SavXgfrav+gLh=xGcL0-Hw@mail.gmail.com
Whole thread Raw
In response to Re: psql: add \create_function command  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
idea: what about custom functions for (each) IDE, which calls psql -c "CREATE FUNCTION ..." when the user saves the file?  (it would easy to prototype for emacs...)
(obviously, this isn't a core feature...)


On Fri, Jan 26, 2024 at 3:19 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:


pá 26. 1. 2024 v 21:17 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I don't know, maybe I have a problem with the described use case. I cannot
> imagine holding the body and head of PL routines in different places and I
> don't understand the necessity to join it.

It seems a little weird to me too, and I would vote against accepting
\create_function as described because I think too few people would
want to use it.  However, the idea of an easy way to pull in a file
and convert it to a SQL literal seems like it has many applications.

+1

Pavel


                        regards, tom lane

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: psql: add \create_function command
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: psql: show current user in prompt