Re: Order by not working
От
Dan Nessett
Тема
Re: Order by not working
Дата
Msg-id
092195EA-31B0-4EFA-B4EE-1F7F3619817C@yahoo.com
Ответ на
Re: Order by not working (David G. Johnston)
Список
Дерево обсуждения
Order by not working Dan Nessett <dnessett@yahoo.com>
Re: Order by not working Peter Coppens <peter.coppens@datylon.com>
Re: Order by not working Dan Nessett <dnessett@yahoo.com>
Re: Order by not working "David G. Johnston" <david.g.johnston@gmail.com>
Re: Order by not working Dan Nessett <dnessett@yahoo.com>
Re: Order by not working Ron <ronljohnsonjr@gmail.com>
Re: Order by not working Laurenz Albe <laurenz.albe@cybertec.at>
Re: Order by not working Ron <ronljohnsonjr@gmail.com>
Re: Order by not working Dan Nessett <dnessett@yahoo.com>
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.g.johnston@gmail.com> wrote:
On Tuesday, February 16, 2021, Dan Nessett <dnessett@yahoo.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.
В списке pgsql-general по дате отправления
От: Alexander Farber
Дата:
