Download PostgreSQL User`s Guide - BITS

Transcript
Chapter 19. SQL Commands
SQL92 allows absolute positioning of the cursor for FETCH, and allows placing the results
into explicit variables.
FETCH ABSOLUTE #
FROM cursor
INTO :variable [, ...]
ABSOLUTE
The cursor should be positioned to the specified absolute row number. All row numbers
in Postgres are relative numbers so this capability is not supported.
:variable
Target host variable(s).
GRANT
Name
GRANT Grants access privilege to a user, a group or all users
Synopsis
GRANT privilege [, ...] ON object [, ...]
TO { PUBLIC | GROUP group | username }
Inputs
privilege
The possible privileges are:
SELECT
Access all of the columns of a specific table/view.
INSERT
Insert data into all columns of a specific table.
UPDATE
Update all columns of a specific table.
DELETE
Delete rows from a specific table.
229