Por favor, poderiam me indicar onde posso encontrar a estrutura/script da tabela producers abaixo ?
O código abaixo consta de uma página de exemplos de exclusão de registros encontrada no link https://www.postgresql.org/docs/current/sql-delete.html
DELETE FROM films USING producers WHERE producer_id = producers.id AND producers.name = 'foo';What is essentially happening here is a join between films and producers, with all successfully joined films rows being marked for deletion. This syntax is not standard. A more standard way to do it is:
DELETE FROM films WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');
Obrigado,
