PSQL, несколько различных заданий - PostgreSQL - Ответ 9349862

    Table "public.bookauthor"
  Column   |  Type   | Modifiers
-----------+---------+-----------
 isbn      | text    | not null
 au_number | numeric | not null
Indexes:
    "bookauthor_pkey" PRIMARY KEY, btree (isbn, au_number)
Foreign-key constraints:
    "bookauthor_au_number_fkey" FOREIGN KEY (au_number) REFERENCES author(au_id)
    "bookauthor_isbn_fkey" FOREIGN KEY (isbn) REFERENCES book(isbn)

=> create table t_bookauthor(isbn text NOT NULL references book(isbn), au_number numeric NOT NULL references author(au_id));

=> \d t_bookauthor
   Table "public.t_bookauthor"
  Column   |  Type   | Modifiers
-----------+---------+-----------
 isbn      | text    | not null
 au_number | numeric | not null
Foreign-key constraints:
    "t_bookauthor_au_number_fkey" FOREIGN KEY (au_number) REFERENCES author(au_id)
    "t_bookauthor_isbn_fkey" FOREIGN KEY (isbn) REFERENCES book(isbn)

Indexes:
    "bookauthor_pkey" PRIMARY KEY, btree (isbn, au_number)

=> create table t_bookauthor(
    isbn text NOT NULL 
        references book(isbn), 
    au_number numeric NOT NULL 
        references author(au_id),
    primary key (isbn, au_number)
);

GRANT SELECT ON table_tbl 
TO userName 
WHERE city = 'Rocklin' 
AND city = 'Roseville' 
AND zips.zipcode = table_tbl.zip;