From: | Dan Nessett <dnessett(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Order by not working |
Date: | 2021-02-16 19:41:08 |
Message-ID: | 092195EA-31B0-4EFA-B4EE-1F7F3619817C@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks to those who responded. I have solved my problem by noting the advice to use a select with order by. In particular, I need to export the data to a csv file anyway, so I use the following copy command:
COPY (SELECT household_name, family_list, street_address, city, state, zip, phone_list, email_list
FROM "household_data"
ORDER BY household_name
)
TO '/tmp/household_data.csv'
WITH (FORMAT CSV, HEADER);
This works.
Regards,
Dan
> On Feb 16, 2021, at 12:35 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>
> On Tuesday, February 16, 2021, Dan Nessett <dnessett(at)yahoo(dot)com <mailto:dnessett(at)yahoo(dot)com>> wrote:
> Thanks Peter. The listing of the result is from pg-admin 4.30 using view/edit data applied to the household_data table. In the past this has always returned the table contents in the ORDR BY sort order. Do I need to specify some preference in pg_admin to guarantee this?
>
> pgAdmin4 might be keying off of the presence of an index, which this table doesn’t have.
>
> David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Farber | 2021-02-16 20:30:59 | Re: How to return a jsonb list of lists (with integers) |
Previous Message | David G. Johnston | 2021-02-16 19:35:00 | Re: Order by not working |