Postgres Pro
Downloads
Home   >   mailing lists

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

From Anthony Apollis
Subject Fwd: TSQL To Postgres - Unpivot/Union All
Date
Msg-id CAJyMCYJDiY6hoLdtM=T2nc8rnZTxBbNOr0mHsJ5v6OPtes6B0Q@mail.gmail.com
Whole thread Raw
In response to Fwd: TSQL To Postgres - Unpivot/Union All  (Anthony Apollis <anthony.apollis@gmail.com>)
Responses Re: TSQL To Postgres - Unpivot/Union All  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
Tree view


---------- Forwarded message ---------
From: Anthony Apollis <anthony.apollis@gmail.com>
Date: Thu, 20 Jul 2023 at 16:07
Subject: Re: TSQL To Postgres - Unpivot/Union All
To: Geoff Winkless <pgsqladmin@geoff.dj>, David G. Johnston <david.g.johnston@gmail.com>


I am attaching my TSQL and Postgres SQL:

On Thu, 20 Jul 2023 at 15:58, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
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
Attachment

pgsql-general by date:

Previous
From: gzh
Date:
Subject: Re: How to improve the performance of my SQL query？
Next
From: Adrian Klaver
Date:
Subject: Re: Nu-B here