Thread: Losing column ordering

guys, I'm losing column ordering. I need original order preserved for easy visualisation. (yes, the data is not normalised, please ignore that.)

I typed country, state, city, followed by the numeric column names. Looks like names are being sorted alphanumerically and carried on to table column ordering.

You need ticket or ?

I'll do a ticket. Here's a ticket: https://redmine.postgresql.org/issues/4720

On Tue, Sep 10, 2019 at 1:46 PM Avin Kavish <avinkavish@gmail.com> wrote:

guys, I'm losing column ordering. I need original order preserved for easy visualisation. (yes, the data is not normalised, please ignore that.)

I typed country, state, city, followed by the numeric column names. Looks like names are being sorted alphanumerically and carried on to table column ordering.

You need ticket or ?

I can see you have clicked the header "Name" (arrow) which sorting it.

On Tue, Sep 10, 2019, 14:14 Avin Kavish <avinkavish@gmail.com> wrote:

I'll do a ticket. Here's a ticket: https://redmine.postgresql.org/issues/4720

On Tue, Sep 10, 2019 at 1:46 PM Avin Kavish <avinkavish@gmail.com> wrote:

guys, I'm losing column ordering. I need original order preserved for easy visualisation. (yes, the data is not normalised, please ignore that.)

I typed country, state, city, followed by the numeric column names. Looks like names are being sorted alphanumerically and carried on to table column ordering.

You need ticket or ?

jesus

On Tue, Sep 10, 2019 at 2:16 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

I can see you have clicked the header "Name" (arrow) which sorting it.

On Tue, Sep 10, 2019, 14:14 Avin Kavish <avinkavish@gmail.com> wrote:

I'll do a ticket. Here's a ticket: https://redmine.postgresql.org/issues/4720

On Tue, Sep 10, 2019 at 1:46 PM Avin Kavish <avinkavish@gmail.com> wrote:

guys, I'm losing column ordering. I need original order preserved for easy visualisation. (yes, the data is not normalised, please ignore that.)

I typed country, state, city, followed by the numeric column names. Looks like names are being sorted alphanumerically and carried on to table column ordering.

You need ticket or ?

And learning about being too trigger-happy with bugtrackers :)

Regards,
Arni

On 10/09/2019 10.55, Avin Kavish wrote:

talk about accidental feature discovery

On Tue, Sep 10, 2019 at 2:18 PM Avin Kavish <avinkavish@gmail.com> wrote:

jesus

On Tue, Sep 10, 2019 at 2:16 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

I can see you have clicked the header "Name" (arrow) which sorting it.

On Tue, Sep 10, 2019, 14:14 Avin Kavish <avinkavish@gmail.com> wrote:

I'll do a ticket. Here's a ticket: https://redmine.postgresql.org/issues/4720

On Tue, Sep 10, 2019 at 1:46 PM Avin Kavish <avinkavish@gmail.com> wrote:

guys, I'm losing column ordering. I need original order preserved for easy visualisation. (yes, the data is not normalised, please ignore that.)

I typed country, state, city, followed by the numeric column names. Looks like names are being sorted alphanumerically and carried on to table column ordering.

You need ticket or ?