plsh
plsh copied to clipboard
petere
PL/sh is a procedural language handler for PostgreSQL that allows you to write stored procedures in a shell of your choice.
When I try to install plsh on CentOS 8 machine, the package does not install. I get the following error.  Tried following the make instructions but running into the...
Scenario: plsh function that runs a script with plsql commands. For example: `create or replace function sp_fact_maintenance_run(get_start_date date DEFAULT (((last_day(('now'::text)::date) - '1 mon'::interval) + '1 day'::interval))::date, get_end_date date DEFAULT (('now'::text)::date...
I found a big drawback in plsh language that the amount of data you can pass to a shell function may hit command line limitation, i.e. no more 254 spaces...
SETOF
While PL/sh will happily create a function returning SETOF TEXT, for example, I don't see a way to actually do such a thing. Is there something clever I've missed? ```...
Hi, thank you very much for this great PG extension. Lately I found some strange problem in my implementation - maybe you could give some advice? In plsh procedure I...
Hallo, I try to understand why the following code fails : (sogo-tool is a binary that accesses a PostgreSQL database) CREATE OR REPLACE FUNCTION showSig() RETURNS text AS ' #!/bin/bash...
i want to execute curl from plsh the procedure looks like # !/.... curl "$1" and $1 looks like 'https://.....ewad.json' -v -X POST --data-urlencode 'address=fdfdf 38' --insecure --data-urlencode 'size=65' --data-urlencode...
Hello if I want to create an pl/sh function I get an error code Permission denied for this language do I have to be a superuser to use this language?...
$ make process_begin: CreateProcess(NULL, pg_config --version, ...) failed. Makefile:3: pipe: No error process_begin: CreateProcess(NULL, pg_config --pgxs, ...) failed. Makefile:24: pipe: No error cp plsh-noinline.sql plsh.sql
