Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows : FETCH FORWARD « Cursor « PostgreSQL

1. PostgreSQL
2. Cursor
3. FETCH FORWARD

Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows

postgres=# CREATE TABLE "publishers" (
postgres(#      "id" integer NOT NULL,
postgres(#      "name" text,
postgres(#      "address" text,
postgres(#      Constraint "publishers_pkey" Primary Key ("id")
postgres(# );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "publishers_pkey" for table "publishers"
CREATE TABLE
postgres=#
postgres=#
postgres=# insert into publishers values(150, 'Can Press',  '29 Ave. Toronto, ON');
INSERT 0 1
postgres=# insert into publishers values(91,  'Henry Inc.', '115 Street New York, NY');
INSERT 0 1
postgres=# insert into publishers values(113, 'O Inc.',     '101 St, Sebastopol, CA');
INSERT 0 1
postgres=# insert into publishers values(62,  'W Pubs',     '1515, New York');
INSERT 0 1
postgres=# insert into publishers values(105, 'N Press',    '19 W, New York');
INSERT 0 1
postgres=# insert into publishers values(99,  'A Inc',      '375 St, New York');
INSERT 0 1
postgres=# insert into publishers values(101, 'Z Inc',      '375 Ave, New York');
INSERT 0 1
postgres=# insert into publishers values(163, 'M Press',    'PO Box 1215');
INSERT 0 1
postgres=# insert into publishers values(171, 'B',          '16 W. 18th St. New York');
INSERT 0 1
postgres=# insert into publishers values(102, 'P Inc',      '375 Hudson St, New York');
INSERT 0 1
postgres=# insert into publishers values(75,  'D Inc',      '1540 Broadway, New York');
INSERT 0 1
postgres=# insert into publishers values(65,  'H Pubs',     '10 E 53rd St, New York');
INSERT 0 1
postgres=# insert into publishers values(59,  'R Inc',      '1540 Broadway, New York');
INSERT 0 1
postgres=#
postgres=# select * from publishers;
 id  |    name    |         address
-----+------------+-------------------------
 150 | Can Press  | 29 Ave. Toronto, ON
  91 | Henry Inc. | 115 Street New York, NY
 113 | O Inc.     | 101 St, Sebastopol, CA
  62 | W Pubs     | 1515, New York
 105 | N Press    | 19 W, New York
  99 | A Inc      | 375 St, New York
 101 | Z Inc      | 375 Ave, New York
 163 | M Press    | PO Box 1215
 171 | B          | 16 W. 18th St. New York
 102 | P Inc      | 375 Hudson St, New York
  75 | D Inc      | 1540 Broadway, New York
  65 | H Pubs     | 10 E 53rd St, New York
  59 | R Inc      | 1540 Broadway, New York
(13 rows)

postgres=#
postgres=# -- Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows.
postgres=#
postgres=#
postgres=# BEGIN WORK;
BEGIN
postgres=# DECLARE cur_publisher CURSOR FOR SELECT name FROM publishers;
DECLARE CURSOR
postgres=# FETCH FORWARD 2 IN cur_publisher;
    name
------------
 Can Press
 Henry Inc.
(2 rows)

postgres=#
postgres=# close cur_publisher;
CLOSE CURSOR
postgres=# END WORK;
COMMIT
postgres=#
postgres=# drop table publishers;
DROP TABLE
postgres=#
postgres=#

           
       

Related examples in the same category