\h open

On 16.09.2013 07:43, Oleg Bartunov wrote:

I noticed there is nothing available in built-in psql help about OPEN
command. Does it intentional ?

That's because there is no OPEN command. PL/pgSQL does have an OPEN
statement, but that's just PL/pgSQL. And ecpg too, but again that's
handled by ecpg, not the backend.

- Heikki

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Oleg Bartunov <obartunov@gmail.com> wrote:

I noticed there is nothing available in built-in psql help about
OPEN command. Does it intentional ?

postgres=# \h open
No help available for "open".
Try \h with no arguments to see available help.

PostgreSQL does not include OPEN as a SQL command:

http://www.postgresql.org/docs/current/interactive/sql-commands.html

DECLARE CURSOR opens the cursor immediately.

Some PLs include an OPEN statement, but psql does not have help for all the PLs.

As an example, plpgsql supports OPEN:

http://www.postgresql.org/docs/current/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-OPENING

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers