Представления

=> CREATE VIEW authors_v AS
SELECT a.author_id,
       a.first_name || ' ' || a.last_name || coalesce(' ' || a.surname, '') AS display_name
FROM   authors a;
CREATE VIEW
=> CREATE VIEW catalog_v AS
SELECT b.book_id,
       b.title AS display_name
FROM   books b;
CREATE VIEW