Определение синонимов для полей

Листинг 4.30. Определение синонимов для полей

booktown=# SELECT the_book_id, title, id, last_name

booktown-# FROM books AS b (the_book_id), authors

booktown-# WHERE author_id = id;

id | title id | last_name

190 | Little Women | 16 | Alcott

156 | The Tell-Tale Heart | 115 Рое

41472 | Practical PostgreSQL | 1212 | Worsley

2038 | Dynamic Anatomy | 1644 | Hogarth

1608 | The Cat in the Hat | 1809 | Geisel

1590 | Bartholomew and the Oobleck | 1809 | Geisel

4513 | Dune | 1866 | Herbert

4267 | 2001: A Space Odyssey | 2001 | Clarke

1501 | Goodnight Moon | 2031 | Brown

7808 | The Shining | 4156 | King

41473 | Programming Python | 7805 | Lutz

41477 | Learning Python | 7805 | Lutz

41478 | Perl Cookbook | 7806 | Christiansen

25908 | Franklin in the Dark | 15990 | Bourgeois

1234 | The Velveteen Rabbit | 25041 | Bianco

(15 rows)