Subject: Re: nothing ever works
To: Gerard Matthews <gerardmatt@gmail.com>,
 Pavel Stehule <pavel.stehule@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 Michael Paquier <michael.paquier@gmail.com>,
 pgsql-docs <pgsql-docs@postgresql.org>
References: <20170621083940.27874.47470@wrigleys.postgresql.org>
 <CAFj8pRBVZSw_COwXxQhPKmucMSPiETKVM0d9sMH6PYRN73CMXg@mail.gmail.com>
 <CAB7nPqSWzvVKvfHz3bt5Cf_bZ1t6m3Qg__a67OWSiODV9T8tgw@mail.gmail.com>
 <CAKFQuwZnmtzwdGfHrd+vtebWCX7F_qna9CepDiZwFPHpiQ6KhA@mail.gmail.com>
 <CAO=GzUhm9buGcS2KZFqZ60cnBV1ezW7PsMVhY4wXLSJy=As-hw@mail.gmail.com>
 <CAO=GzUgrZNqWb0RPHvsWz=mTDV0sH8-eL+x0AceHa6OJqfr+uQ@mail.gmail.com>
 <CAFj8pRCf=sm8QMizxWb0vYVi6PhC4zchv_3guDLCORCaFRX6Gw@mail.gmail.com>
 <CAO=GzUjXrZp81NNqgDu3bEPpftMN9hvLf1oWxx8M9nvGS45hOg@mail.gmail.com>
From: Joe Conway <mail@joeconway.com>
Openpgp: id=4EA5B4659ED59CC9538139A5332B7E68B699434A
Message-ID: <bbf66634-3fc5-06d4-baee-64f3b198197e@joeconway.com>
Date: Thu, 22 Jun 2017 16:25:08 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.1
MIME-Version: 1.0
In-Reply-To: 
 <CAO=GzUjXrZp81NNqgDu3bEPpftMN9hvLf1oWxx8M9nvGS45hOg@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="VUx4BF4JfUfvsnePcDg5PLG2iqbSbhXIH"
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--VUx4BF4JfUfvsnePcDg5PLG2iqbSbhXIH
From: Joe Conway <mail@joeconway.com>
To: Gerard Matthews <gerardmatt@gmail.com>,
 Pavel Stehule <pavel.stehule@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 Michael Paquier <michael.paquier@gmail.com>,
 pgsql-docs <pgsql-docs@postgresql.org>
Message-ID: <bbf66634-3fc5-06d4-baee-64f3b198197e@joeconway.com>
Subject: Re: [DOCS] nothing ever works
References: <20170621083940.27874.47470@wrigleys.postgresql.org>
 <CAFj8pRBVZSw_COwXxQhPKmucMSPiETKVM0d9sMH6PYRN73CMXg@mail.gmail.com>
 <CAB7nPqSWzvVKvfHz3bt5Cf_bZ1t6m3Qg__a67OWSiODV9T8tgw@mail.gmail.com>
 <CAKFQuwZnmtzwdGfHrd+vtebWCX7F_qna9CepDiZwFPHpiQ6KhA@mail.gmail.com>
 <CAO=GzUhm9buGcS2KZFqZ60cnBV1ezW7PsMVhY4wXLSJy=As-hw@mail.gmail.com>
 <CAO=GzUgrZNqWb0RPHvsWz=mTDV0sH8-eL+x0AceHa6OJqfr+uQ@mail.gmail.com>
 <CAFj8pRCf=sm8QMizxWb0vYVi6PhC4zchv_3guDLCORCaFRX6Gw@mail.gmail.com>
 <CAO=GzUjXrZp81NNqgDu3bEPpftMN9hvLf1oWxx8M9nvGS45hOg@mail.gmail.com>
In-Reply-To: <CAO=GzUjXrZp81NNqgDu3bEPpftMN9hvLf1oWxx8M9nvGS45hOg@mail.gmail.com>
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=utf-8
Content-Language: en-US

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

--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


--VUx4BF4JfUfvsnePcDg5PLG2iqbSbhXIH
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJZTFHUAAoJEDfy90M199hlAPUP/iONKhsCxES5n+YdCDEOTXJ4
l0WUFqCVagfflAAgfa0K/hu6Sk76IOlawh9m/768ommd7YrIEpJQC+sI374e6qag
wrJuY+0xZXCeEzq6ba62fTAnlhA3OQHy4bZ7sYwlgo7l37xrTU5+lxjE9Ev/gYCK
EvgX8XeZcNyuy/Z8S/6SAQ9c712AAjfet5QVg4U2GMO1H80SNyMqtIGYGs0kQJVP
wHpGOn7y0lB1vnldmeuf5gqvSyEXmeaVZ+YtUbipbr9LMSsDaYQKI7psOCc6FWai
gol1dsFAWax4WmQ/sHpp4DUIWoM6vc3LyceB5sXK85DTENMHfGn2V3FGL8NCLZjK
+rtxIqV9nQjLu+Z1yhO+Hjb5EO/3ciGZrRYa/6iNCG/qAEjX6Jn68dvcwXqO1Lys
xpuc1joTN8qKXcoMY/5Y2OMeYtoov3kfmPqSIteCZ+Wec9P8Z/riziudGAXJitoB
YxRyY8jEeDbbqNu6SLWjvjZxrpxSewLj+9Ab4rZ1dbEv83RYBLB/JKv3iG3XnpJJ
5Bf7/D0U2IXUtssncNxzoMrI8g4cDSar2Kj7TJH4wWMpqtCifPF6IG5AdF4WErcY
tM4n8KkMNVYLkFTdHA5r8NqotXCm7qorD4hC9x83gZC2Zhak3qmJ0Uj1ah/NFz4j
qlS7h819nUMtecpTIMgA
=IBif
-----END PGP SIGNATURE-----

--VUx4BF4JfUfvsnePcDg5PLG2iqbSbhXIH--