Re: psql: add \create_function command

From: walther(at)technowledgy(dot)de
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Steve Chavez <steve(at)supabase(dot)io>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql: add \create_function command
Date: 2024-01-26 19:45:16
Message-ID: d61e45eb-d25e-42ab-b847-ce1c0183a2e0@technowledgy.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pavel Stehule:
> looks a little bit obscure - why do you need to do it from psql? And how
> frequently do you do it?

I store all my SQL code in git and use "psql -e" to "bundle" it into an
extension, which is then deployed to production.

The code is spread over many files, which include other files via \ir.
Sometimes you need to include other types of files, though - for example
code in other languages as Steve mentioned, but I have also had cases
for yaml files, markdown templates, even binary assets which should
still be considered "code" and not data.

So anything in that direction would help.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tristan Partin 2024-01-26 19:46:36 Re: make dist using git archive
Previous Message walther 2024-01-26 19:38:34 Re: psql: add \create_function command