Re: Questions on dynamic execution and sqlca - Mailing list pgsql-general

From David Johnston
Subject Re: Questions on dynamic execution and sqlca
Date
Msg-id CAKFQuwZD7RoGCjKTxd839FwJqZYsU5maCQzNG=K2v=pNUmgrRQ@mail.gmail.com
Whole thread Raw
In response to Re: Questions on dynamic execution and sqlca  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Questions on dynamic execution and sqlca  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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.​

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Questions on dynamic execution and sqlca
Next
From: David G Johnston
Date:
Subject: Re: Avoid WAL archiving when idle?