Re: TSQL To Postgres - Unpivot/Union All

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