Re: nothing ever works

Thank you very much guys. I'm on the right path now.

On Fri, 23 Jun 2017 at 01:25 Joe Conway <mail(at)joeconway(dot)com> wrote:

> On 06/22/2017 04:29 AM, Gerard Matthews wrote:
> > It's under this page on the
> > docs https://www.postgresql.org/docs/9.1/static/ecpg-dynamic.html.
>
> Perhaps a bit confusing but notice the title in the top middle of the
> page: "Chapter 33. ECPG - Embedded SQL in C"
>
> That is definitely not what you are looking for by the sound of it. As
> others have pointed out, most likely you want plpgsql:
>
> https://www.postgresql.org/docs/current/static/plpgsql.html
>
> although you can also write dynamic SQL in other Procedural Languages
> which ship with Postgres, for example plpython and plperl:
>
> https://www.postgresql.org/docs/current/static/plpython.html
> https://www.postgresql.org/docs/current/static/plperl.html
>
> Note however, while plpgsql is installed into your database by default,
> plperl and plpython are not, so you would have to log into the database
> of interest and run the following (once), e.g. (only do for the language
> of interest, not all three; also note that depending on how you
> installed Postgres, you might need to also install extra packages):
>
> CREATE EXTENSION plperl;
> CREATE EXTENSION plpythonu;
> CREATE EXTENSION plperlu;
>
> Also note the difference between "trusted" and "untrusted" procedural
> languages. plpgsql and plperl are "trusted" while plperlu and plpythonu
> are "untrusted". See this link for an explanation:
>
> https://www.postgresql.org/docs/current/static/plperl-trusted.html
>
> Hope this helps.
>
> Joe
>
> --
> Crunchy Data - http://crunchydata.com
> PostgreSQL Support for Secure Enterprises
> Consulting, Training, & Open Source Development
>
>