Re: Questions on dynamic execution and sqlca

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Questions on dynamic execution and sqlca
Дата
Msg-id CAECtzeWDz1RBfzQbb7KUyrLVrXuAGOuPUkyoGUF9x3+HGT1CNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Questions on dynamic execution and sqlca  (David Johnston <david.g.johnston@gmail.com>)
Список pgsql-general
2014-08-07 7:24 GMT+02:00 David Johnston <david.g.johnston@gmail.com>:


> > - 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.


No problem :)

pgscript reference is available on http://pgadmin.org/docs/1.18/pgscript.html.

Note that pgScript isn't specific to pgAdmin, AFAIK.


--

В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Avoid WAL archiving when idle?
Следующее
От: Jorge Arevalo
Дата:
Сообщение: Re: Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method