delete from multiple tables

From: Hans Ginzel <hans(at)matfyz(dot)cz>
To: pgsql-novice(at)postgresql(dot)org
Subject: delete from multiple tables
Date: 2015-02-05 07:13:19
Message-ID: 20150205071319.GB123481@artax.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello!

How to delete from multiple tables, please?

DELETE t1, t2
FROM table1 AS t1
JOIN table2 AS t2 ON t1.fkey = t2.pkey
WHERE ...

Best regards
Hans

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2015-02-05 07:35:20 Re: delete from multiple tables
Previous Message Tom Lane 2015-02-04 16:28:34 Re: How to round a double8 data type in sql?