Skip site navigation (1) Skip section navigation (2)

Clarification of psql's "-c" output

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-docs(at)postgresql(dot)org
Subject: Clarification of psql's "-c" output
Date: 2009-04-14 14:33:58
Message-ID: m3myajxq21.fsf@lockfix.tim-landscheidt.de (view raw or flat)
Thread:
Lists: pgsql-docs
Hi,

as a user, I'd appreciate if psql's execution and output be-
haviour when using the "-c" option would be explained more
detailed in the documentation. Based on psql 8.*3*.7 (don't
know if that will change in 8.4), I'd suggest:

| [tim(at)lockfix ~/Desktop/Agenda/pgsql/doc/src/sgml/ref]$ cvs diff -u psql-ref.sgml
| Index: psql-ref.sgml
| ===================================================================
| RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v
| retrieving revision 1.223
| diff -u -r1.223 psql-ref.sgml
| --- psql-ref.sgml       8 Apr 2009 22:29:30 -0000       1.223
| +++ psql-ref.sgml       14 Apr 2009 14:30:17 -0000
| @@ -99,6 +99,15 @@
|         string to divide it into multiple transactions.  This is
|         different from the behavior when the same string is fed to
|         <application>psql</application>'s standard input.
| +       Only the result of the <emphasis>last
| +       explicit</emphasis> SQL command (i. e. not a
| +       transaction wrapper added
| +       by <application>psql</application>) is displayed.
| +      </para>
| +      <para>
| +       If multiple <option>-c</option> options are given,
| +       only the <emphasis>last</emphasis> option is
| +       evaluated.
|        </para>
|        </listitem>
|      </varlistentry>
| [tim(at)lockfix ~/Desktop/Agenda/pgsql/doc/src/sgml/ref]$

TIA,
Tim

pgsql-docs by date

Next:From: Bruce MomjianDate: 2009-04-15 22:42:54
Subject: Re: Inheritance mention
Previous:From: Tom LaneDate: 2009-04-13 17:21:46
Subject: Re: Inheritance mention

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group