Creates a view of all publishers whose names begin with H : Create View « View « PostgreSQL






Creates a view of all publishers whose names begin with H


postgres=#
postgres=# CREATE TABLE "publishers" (
postgres(#      "id" integer NOT NULL,
postgres(#      "name" text,
postgres(#      "address" text,
postgres(#      Constraint "publishers_pkey" Primary Key ("id")
postgres(# );
postgres=#
postgres=#
postgres=# insert into publishers values(150, 'Can Press',  '29 Ave. Toronto, ON');
postgres=# insert into publishers values(91,  'Henry Inc.', '115 Street New York, NY');
postgres=# insert into publishers values(113, 'O Inc.',     '101 St, Sebastopol, CA');
postgres=# insert into publishers values(62,  'W Pubs',     '1515, New York');
postgres=# insert into publishers values(105, 'N Press',    '19 W, New York');
postgres=# insert into publishers values(99,  'A Inc',      '375 St, New York');
postgres=# insert into publishers values(101, 'Z Inc',      '375 Ave, New York');
postgres=# insert into publishers values(163, 'M Press',    'PO Box 1215');
postgres=# insert into publishers values(171, 'B',          '16 W. 18th St. New York');
postgres=# insert into publishers values(102, 'P Inc',      '375 Hudson St, New York');
postgres=# insert into publishers values(75,  'D Inc',      '1540 Broadway, New York');
postgres=# insert into publishers values(65,  'H Pubs',     '10 E 53rd St, New York');
postgres=# insert into publishers values(59,  'R Inc',      '1540 Broadway, New York');
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=# -- Creates a view of all publishers whose names begin with H:
postgres=#
postgres=# CREATE VIEW h_publishers AS
postgres-#         SELECT * FROM publishers WHERE name LIKE 'H%';
CREATE VIEW
postgres=#
postgres=# select * from h_publishers;
 id |    name    |         address
----+------------+-------------------------
 91 | Henry Inc. | 115 Street New York, NY
 65 | H Pubs     | 10 E 53rd St, New York
(2 rows)

postgres=#
postgres=# drop view h_publishers;
DROP VIEW
postgres=# drop table publishers;
DROP TABLE
postgres=#
postgres=#
           
       








Related examples in the same category

1.Create view from the user defined function
2.Creating a view with a natural join statement