Re: New version of psql

On 1999-11-04, Bruce Momjian mentioned:

> OK, new version of psql installed. Only problem I see is that \h shows
> TRUNCATE as the first help item. I assume the directory contents are
> not being sorted. Peter?
>
> Second, the new psql prompt is #, so it shows as:
>
> test-#
>
> Not sure I like that. I liked the > better, I think, unless # grows on
> me.

The new prompt is the same as the the old one. *** Scratches head ***

The '>' is replaced by a '#' if you are the superuser. (Correction: if the
username is "postgres". I'm still thinking about ways to make this a
little more elegant though. Ideas welcome.)

The '-' shouldn't be there unless you're in continue mode, as usual. Works
for me:

testdb=> select *
testdb-> from foo;
ERROR: foo: Table does not exist.
testdb=> \c - postgres
You are now connected as new user postgres.
testdb=# select *
testdb-# from foo;
ERROR: foo: Table does not exist.

Of course you can also completely customize your prompt. See the docs for
that.

-Peter

--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden