Postgres Pro
Downloads
Home   >   mailing lists

Re: TSQL To Postgres - Unpivot/Union All - Mailing list pgsql-general

From Geoff Winkless
Subject Re: TSQL To Postgres - Unpivot/Union All
Date
Msg-id CAEzk6ffszUabGjDhBOCZqTP0PoMzLaJtnu+=ye2snMVSOy=b4w@mail.gmail.com
Whole thread Raw
In response to Fwd: TSQL To Postgres - Unpivot/Union All  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
Tree view
On Thu, 20 Jul 2023 at 13:17, Anthony Apollis <anthony.apollis@gmail.com> wrote:
The Postgres i used: INSERT INTO temp_FieldFlowsFact
SELECT "Account", "Calendar day", "Financial year", "Period",

[snip]

At the very least, include a column list in your INSERT statement. We have no way of checking where any of your results are going.

Geoff

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: TSQL To Postgres - Unpivot/Union All
Next
From: gzh
Date:
Subject: Re: How to improve the performance of my SQL query？