> > Try along the lines of > > psql -h some.host.com -U postgres -v "PROMPT1=*my_cool_prompt%/> " -d my_db > Works like a charm! Do I have a dot file that I can save this setting to, similar to the .exrc for vi, or will I need to enter it every time? If the latter, I'll alias it, but I'd rather be able to save it if possible. Thanks! Sent - Gtek Web Mail -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general