Postgres Pro
Downloads
Home   >   mailing lists

Thread: \h open

\h open

From
Oleg Bartunov
Date:
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.

Oleg

Re: \h open

From
Heikki Linnakangas
Date:
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

Re: \h open

From
Kevin Grittner
Date:
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