psql: absolutes and toggles

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: psql: absolutes and toggles
Date: 2006-08-07 18:10:47
Message-ID: 44D78227.7080200@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

We create psql scripts that can be used at various times by various
users. I have been unable to find how to absolutely set various options
(timing, expanded, etc.) rather than toggle them.

The --no-psqlrc option provides a partial workaround - as long as the
user remembers to include it and as long as they are only running the
one script. But if they forget or if they are already running a session
there is no telling what settings have been toggled by previously run
scripts or the users themselves.

So...have I overlooked an interactive psql option that will let me reset
all options to "factory-defaults" or a method of specifying an absolute
setting to the various options?

If not, do psql users out there feel this is worth a feature request?

Cheers,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2006-08-07 18:20:01 Varchar concatenate fields as Char or Varchar, not Text
Previous Message Marian POPESCU 2006-08-07 17:02:12 Re: XPath question - big trouble

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-07 18:14:22 Re: buildfarm - make check failures for leveret on 8.0 and 8.1
Previous Message Rod Taylor 2006-08-07 17:57:05 Re: "Constraint exclusion" is not general enough