Search Postgresql Archives

Re: TSQL To Postgres - Unpivot/Union All

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: TSQL To Postgres - Unpivot/Union All
From: Geoff Winkless <pgsqladmin@xxxxxxxx>
Date: Thu, 20 Jul 2023 14:58:06 +0100
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAJyMCYLL-mMuCfXT8M1kD-=6=r8YHHrSGbT-rN25vCwtVyr1jg@mail.gmail.com>
References: <CAJyMCYJ+JGpHtpV36UP+kUAW4LoprmgbgDPLCpe_8A0xbe=GZA@mail.gmail.com> <CAJyMCYLL-mMuCfXT8M1kD-=6=r8YHHrSGbT-rN25vCwtVyr1jg@mail.gmail.com>

On Thu, 20 Jul 2023 at 13:17, Anthony Apollis <anthony.apollis@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Fwd: TSQL To Postgres - Unpivot/Union All
  - From: Anthony Apollis

Prev by Date: Re: TSQL To Postgres - Unpivot/Union All
Next by Date: Re: How to improve the performance of my SQL query？
Previous by thread: Re: TSQL To Postgres - Unpivot/Union All
Next by thread: Fwd: TSQL To Postgres - Unpivot/Union All
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux