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 lo
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
wrote:
> On 02/13/2018 12:38 PM, Sherman Willden wrote:
>
>> develop
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 ta
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
Basi
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', 'Ba
mmm, 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)&
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
The database table has five columns; 'id aria artist a_artist album_title'.
I assume I will use a SELECT * FROM aria_precis WHERE type command.
I want to access all arias that have mio ben within the aria title. In the
example below I want to display cbiylm06 and cbiylm10.
cbiylm06#Caro mio ben#C