Re: Find duplicates in a column then print Information to a file

Rob Sargent writes: > Keep in mind there is a quick write-to-file in psql with ‘\o ’. And > don’t forget to turn it off with ‘\o’ See also "\g filename", for one-shot output. regards, tom lane

Re: Find duplicates in a column then print Information to a file

Keep in mind there is a quick write-to-file in psql with ‘\o ’. And don’t forget to turn it off with ‘\o’ > On Dec 31, 2017, at 12:04 PM, Sherman Willden wrote: > > Thank you for the replies. I will start working on them now. Not a student > but since I now have the

Re: Find duplicates in a column then print Information to a file

Thank you for the replies. I will start working on them now. Not a student but since I now have the time I may look into it. I am 71 retired working at Home Depot. I have a collection of CDs by various artists and I have the time to create and maintain my own database concerning these subjects. I

Re: Find duplicates in a column then print Information to a file

M, I notice a faint homework smell here ;-> , but the question is nicely asked so: On Sun, Dec 31, 2017 at 7:19 PM, Sherman Willden wrote: ... > SELECT aria FROM aria_precis WHERE aria IN (SELECT aria FROM aria_precis > GROUP BY aria HAVING COUNT(aria)>1); The

Re: Find duplicates in a column then print Information to a file

From: Sherman Willden Date: Sunday, 31 December 2017 at 18:19 To: Subject: Find duplicates in a column then print Information to a file Development Platform: Ubuntu 17.10 mainly command line work Tools: perl 5.26 and postgresql 9.6

Find duplicates in a column then print Information to a file

Development Platform: Ubuntu 17.10 mainly command line work Tools: perl 5.26 and postgresql 9.6 Goal: Display duplicate aria titles on screen and to a local file Database name: arias Table name: aria_precis csv delimiter: the # symbol arias=# \d aria_precis Table "public.aria_precis"