| From: | David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Questions on dynamic execution and sqlca |
| Date: | 2014-08-07 05:24:24 |
| Message-ID: | CAKFQuwZD7RoGCjKTxd839FwJqZYsU5maCQzNG=K2v=pNUmgrRQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
>
> > > - What are the differences among PL/SQL, PL/PGSQL and pgScript.
> >
> > The first two are languages you write functions in. pgScript is simply
> an
> > informal way to group a series of statements together and have them
> execute
> > within a transaction.
> >
>
> AFAICT, this isn't true. Pgscript is a client specific language. There is
> a whole description of what it can do in pgadmin's manual. This was
> interesting when PostgreSQL didn't have the DO statement. Now that we do,
> it's rather pointless.
>
>
>
Yeah, I probably should have either researched the answer or just left it
alone. I am not all that familiar with pgAdmin - I figured it was just a
souped up script runner with maybe a couple of features like variables but
otherwise allowing only SQL commands.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2014-08-07 05:37:56 | Re: Avoid WAL archiving when idle? |
| Previous Message | Guillaume Lelarge | 2014-08-07 05:16:45 | Re: Questions on dynamic execution and sqlca |