Manual query vs trigger during data load

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Manual query vs trigger during data load
Date: 2024-09-13 07:49:59
Message-ID: 0fcc526e-752d-455d-936a-3ccc97cb95e3@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

To me it seems possible to create an insert select, e.g.

Insert into tab1 (val1, val2)
Select valA, valB
From tab2
Where valC = :param1

Cheers

Thiemo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ebubekir Büyüktosun 2024-09-13 08:29:48 Storing plans with pg_stat_statements
Previous Message yudhi s 2024-09-13 07:31:58 Manual query vs trigger during data load