Received: from frithjof.reiner (a99.dialin.tuwien.ac.at [192.35.240.109]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f13H6Gq18504 for ; Sat, 3 Feb 2001 12:06:20 -0500 (EST) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 214 invoked by uid 500); 2 Feb 2001 19:30:00 -0000 From: "Albert REINER" Date: Fri, 2 Feb 2001 20:30:00 +0100 To: PostgreSQL-SQL Subject: Re: Suggestion for psql: --file - Message-ID: <20010202203000.A202@frithjof> Mail-Followup-To: PostgreSQL-SQL References: <20010130232028.A1380@frithjof> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from peter_e@gmx.net on Fri, Feb 02, 2001 at 04:16:05PM +0100 X-Archive-Number: 200102/20 X-Sequence-Number: 1188 On Fri, Feb 02, 2001 at 04:16:05PM +0100, Peter Eisentraut wrote: > Albert REINER writes: ... > > P.S: BTW, the man page (7.0.2) of psql is not very clear: it took me > > some experimentation to find out that you have to do "\set VARIABLE" > > interactively or give "--set VARIABLE=" to set a variable that does > > not take a value. > > Suggested new wording? What about: -v, --variable, --set variable[=[value]] Performs a variable assignment, like the \set internal command. Note that you must separate name and value, if any, by an equal sign on the command line. To unset a variable, leave off the equal sign and the value. To just set a variable without a value, use the equal sign but leave off the value. These assignments are done during a very early state of startup, so variables reserved for internal purposes might get overwritten later. Albert. -- -------------------------------------------------------------------------- Albert Reiner Deutsch * English * Esperanto * Latine --------------------------------------------------------------------------