Re: SQL Comments

Greg Copeland <greg(at)copelandconsulting(dot)net> writes:
> Should the version number be considered for output when psql is started
> up for interactive use? I'm fairly sure I would of caught this my self
> if a version number were there to key off of.

> Perhaps it should say something like:
> Welcome to psql, the PostgreSQL (v7.3.1) interactive terminal.

I think
Welcome to psql v7.3, the PostgreSQL interactive terminal.
would read more naturally ... seems like a good idea in principle
though, especially since 7.3 is going to introduce a *lot* of breakage
for the backslash commands of older psql versions.

> Maybe even a slash command which not only shows the postgres version
> that psql was compiled from but also the server version it's currently
> connected with?

> Example:
> # \v
> PSQL version 7.3.1
> Backend version 7.3.1

Maybe. Peter, any opinion about that?

regards, tom lane