Postgres Pro
Downloads
Home   >   mailing lists

delete from multiple tables - Mailing list pgsql-novice

From Hans Ginzel
Subject delete from multiple tables
Date
Msg-id 20150205071319.GB123481@artax.karlin.mff.cuni.cz
Whole thread Raw
Responses Re: delete from multiple tables  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to round a double8 data type in sql?
Next
From: Andreas Kretschmer
Date:
Subject: Re: delete from multiple tables