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
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 time I may look into it. I
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
r
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 outer select is fully redundan
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
Goal: Display duplicate aria titles on screen and to a
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"
Co
