Re: Order by not working

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 16 Feb 2021 16:11:02 -0600



    SQL is only intuitive to people who've done programming... :)

    
    Also, since your table names are only composed of lower case and
    underscores, the double quotes are not needed.

    
    On 2/16/21 1:41 PM, Dan Nessett wrote:

    
      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@xxxxxxxxx>
              wrote:
            

              On Tuesday, February 16, 2021, Dan Nessett <dnessett@xxxxxxxxx> 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.
            
          
    -- 

      Angular momentum makes the world go 'round.