Unix Technical Forum

get rid of psql welcome message

This is a discussion on get rid of psql welcome message within the pgsql Hackers forums, part of the PostgreSQL category; --> Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it was proposed to truncate the psql welcome screen. What do you think about that? Personally, I'd ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 04:11 PM
Peter Eisentraut
 
Posts: n/a
Default get rid of psql welcome message

Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it
was proposed to truncate the psql welcome screen. What do you think about
that?

Personally, I'd get rid of it all, because it gets boring after about three
uses, so that we would be at

peter@colt:~$ psql testdb
testdb=#

The version mismatch warning would remain, of course.

I'd also like to get rid of the SSL notice but I'm not sure what to replace it
by. Something in the prompt perhaps?

Btw., any user could put the welcome message in his own psqlrc file via \echo
commands in case they are really attached to it.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 04:11 PM
Magnus Hagander
 
Posts: n/a
Default Re: get rid of psql welcome message

Peter Eisentraut wrote:
> Around
> <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php>
> it was proposed to truncate the psql welcome screen. What do you
> think about that?
>
> Personally, I'd get rid of it all, because it gets boring after about
> three uses, so that we would be at


If we have readline installed, we could perhaps have it show the first
time you launch psql, but if there is a .psql_history file around,
don't show it?


> peter@colt:~$ psql testdb
> testdb=#
>
> The version mismatch warning would remain, of course.
>
> I'd also like to get rid of the SSL notice but I'm not sure what to
> replace it by. Something in the prompt perhaps?


That would work. It just has to keep being possible to quickly see if
a connection is secured.

//Magnus

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-17-2008, 04:11 PM
Simon Riggs
 
Posts: n/a
Default Re: get rid of psql welcome message

On Thu, 2008-04-17 at 14:39 +0200, Peter Eisentraut wrote:

> Personally, I'd get rid of it all, because it gets boring after about three
> uses, so that we would be at


Many people I speak to use Postgres every 6 months or so, so changes
like this make them think its broke when its not.

I'd vote No, because personally I find software that changes for no good
reason to be boring, potentially bug causing and requires many
screenshots and HOWTOs of the software to become outdated.

I do strongly support your efforts to improve usability though but let's
keep stuff that works the same.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-17-2008, 04:11 PM
Stephen Frost
 
Posts: n/a
Default Re: get rid of psql welcome message

* Peter Eisentraut (peter_e@gmx.net) wrote:
> Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it
> was proposed to truncate the psql welcome screen. What do you think about
> that?


I'd recommend an option in .psqlrc to disable it, if possible. That
would be in line with what alot of other "splash-screen" type things do.

Thanks,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIB1DcrzgMPqB3kigRAgkOAJwKP+VJAQUpnq7PH8g1Fz ceXn+qjgCZAUVN
B7f1Yjuc3jKumveB9z4Ch+E=
=qjaI
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-17-2008, 04:11 PM
paul rivers
 
Posts: n/a
Default Re: get rid of psql welcome message

Peter Eisentraut wrote:
> Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it
> was proposed to truncate the psql welcome screen. What do you think about
> that?
>
> Personally, I'd get rid of it all, because it gets boring after about three
> uses, so that we would be at
>
> peter@colt:~$ psql testdb
> testdb=#
>
> The version mismatch warning would remain, of course.
>
> I'd also like to get rid of the SSL notice but I'm not sure what to replace it
> by. Something in the prompt perhaps?
>
> Btw., any user could put the welcome message in his own psqlrc file via \echo
> commands in case they are really attached to it.
>
>


If you do this, adding psql internal variables so a prompt could be
built would be a nice way to go. For a default, perhaps nothing special
at all to flag the connection as ssl? If it matters to someone, they can
always set their prompt default to include this, set pgsslmode
appropriately, or call ensure sslinfo is installed and use it.

Is it worth promoting sslinfo into the core and adding a few new
functions to expose at least the same information (cypher, etc)? While
this isn't strictly related to what you're up to, sslinfo is a very nice
complement for arbitrary programs to confirm they are talking ssl.



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-17-2008, 04:11 PM
Mike Aubury
 
Posts: n/a
Default Re: get rid of psql welcome message

Am I missing something..


$ psql -q testdb
testdb=#

And - if you're using bash - you could just



$ alias "psql=psql -q"
$ psql testdb
testdb=#


On Thursday 17 April 2008 13:39:43 Peter Eisentraut wrote:
> Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php>
> it was proposed to truncate the psql welcome screen. What do you think
> about that?
>
> Personally, I'd get rid of it all, because it gets boring after about three
> uses, so that we would be at
>
> peter@colt:~$ psql testdb
> testdb=#
>
> The version mismatch warning would remain, of course.
>
> I'd also like to get rid of the SSL notice but I'm not sure what to replace
> it by. Something in the prompt perhaps?
>
> Btw., any user could put the welcome message in his own psqlrc file via
> \echo commands in case they are really attached to it.




--
Mike Aubury

Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-17-2008, 04:11 PM
A. Kretschmer
 
Posts: n/a
Default Re: get rid of psql welcome message

am Thu, dem 17.04.2008, um 14:39:43 +0200 mailte Peter Eisentraut folgendes:
> Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it
> was proposed to truncate the psql welcome screen. What do you think about
> that?
>
> Personally, I'd get rid of it all, because it gets boring after about three
> uses, so that we would be at
>
> peter@colt:~$ psql testdb
> testdb=#


I'd vote No, because i see very often on #irc people asking something
like 'how can i see the table definition' or other, and in this cases
it's easy to say: hey dude, read the fine welcome message *g*


Okay, maybe a new switch on the command-line or a .psqlrc-parameter to
suppress this message...



Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-17-2008, 04:11 PM
Peter Eisentraut
 
Posts: n/a
Default Re: get rid of psql welcome message

Mike Aubury wrote:
> Am I missing something..
>
> $ psql -q testdb
> testdb=#


This also quiets out a few other unrelated things.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-17-2008, 04:11 PM
Peter Eisentraut
 
Posts: n/a
Default Re: get rid of psql welcome message

A. Kretschmer wrote:
> I'd vote No, because i see very often on #irc people asking something
> like 'how can i see the table definition' or other, and in this cases
> it's easy to say: hey dude, read the fine welcome message *g*


I take this as evidence that the welcome message has limited use in practice.
The recently added "help" command will probably be (minimally) more suited to
these kinds of people.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 04-17-2008, 04:11 PM
Simon Riggs
 
Posts: n/a
Default Re: get rid of psql welcome message

On Thu, 2008-04-17 at 09:30 -0400, Stephen Frost wrote:
> * Peter Eisentraut (peter_e@gmx.net) wrote:
> > Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php> it
> > was proposed to truncate the psql welcome screen. What do you think about
> > that?

>
> I'd recommend an option in .psqlrc to disable it, if possible. That
> would be in line with what alot of other "splash-screen" type things do.


+1

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:23 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com