Need followup setup instructions to postgresql-10.3-1-linux-x64.run

Name: Sherman Platform: HP Compaq 6710b Operating System: Ubuntu 17.10 Fresh Install postgresql: 10 Fresh Install. No other versions What post-setup must I perform to get postgresql 10 running. I used postgresql-10.3-1-linux-x64.run which ran great. It place postgresql in /opt/PostgreSql. I am

Re: How do I get rid of database test-aria

Yes the double quotes worked. I tried single quotes but since that didn't work I just assumed that double quotes would not work either. Thanks all; Sherman On Tue, Feb 13, 2018 at 1:41 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 02/13/2018 12:38 PM, Sherman Will

How do I get rid of database test-aria

development platform: HP Compaq 6710b postgresql 9.6 Operating System: Ubuntu 17.10 It probably doesn't matter since there is nothing in the database. I don't remember how I created the database. It appears that postgresql does not like a dash in the database name. I have not tried to create a

Best non-networked front end for postgresql

Name: Sherman Single laptop: Compaq 6710b Operating System: Ubuntu 17.10 Postgresql: 9.6 Used for: Just me and my home database Seeking advice: Best non-networked front-end Considerations: I am retired and want to create my own database and database captures. I have experience with PERL

Insert results in 0 1

Computer HP Compaq 6710b Development Platform: Ubuntu 17.10 mainly command line work Tools: perl 5.26 and postgresql 9.6 Why do I get a 0 1 when using insert? Thanks; Sherman classical=# INSERT INTO string_groups VALUES('et_b_02', 'Sonata in B minor', 'Eroica Trio', 'Jean Baptiste Loeillet',

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

ola...@peoplecall.com> wrote: > 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 > <operasopra...@gmail.com> wrote: > ... > > SELECT aria FROM aria_precis WHERE aria IN (SELECT

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"