Re: psql: add \create_function command

From: walther(at)technowledgy(dot)de
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Steve Chavez <steve(at)supabase(dot)io>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql: add \create_function command
Date: 2024-01-26 19:38:34
Message-ID: 52afb85b-35d9-4290-82cd-b8c95fda53c7@technowledgy.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane:
> Or we could cut out the intermediate variable altogether
> by inventing something that works like :'...' but reads
> from a file not a variable. That might be too specialized
> though, and I'm not sure about good syntax for it either.
> Maybe like
>
> CREATE FUNCTION foo() RETURNS whatever AS :{source_file.txt} LANGUAGE ...;

That would indeed be very useful! I would immediately use this in a lot
of places.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message walther 2024-01-26 19:45:16 Re: psql: add \create_function command
Previous Message Jeff Davis 2024-01-26 19:34:26 Re: Improve WALRead() to suck data directly from WAL buffers when possible