Re: Proposal: new border setting in psql

On Thu, 21 Aug 2008 23:22:28 +0300
"Asko Oja" <ascoja@gmail.com> wrote:
> The idea would be to use psql as backend for some other system?
> Or what do you mean by fed directly?

No, I meant that one would do any ad hoc query and cut and paste the
output directly into a tracking tool that supports ReST.  As I
explained in another message though, this is a nice side effect for me
and is the reason that I have an interest in coding it but it really is
a logical extension of what we have anyway.  Look how simple the
documentation change would be.  If you left out the extra example it's
a one line difference.

Index: src/sgml/ref/psql-ref.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v
retrieving revision 1.209
diff -u -p -u -r1.209 psql-ref.sgml
--- src/sgml/ref/psql-ref.sgml  3 Jul 2008 03:37:16 -0000       1.209
+++ src/sgml/ref/psql-ref.sgml  21 Aug 2008 20:31:24 -0000
@@ -1570,7 +1570,7 @@ lo_import 152801          <acronym>HTML</acronym> mode, this will translate directly
intothe <literal>border=...</literal> attribute, in the          others only values 0 (no border), 1 (internal dividing
lines),
-          and 2 (table frame) make sense.
+          2 (table frame) and 3 (individual cells) make sense.          </para>          </listitem>
</varlistentry>
@@ -2973,6 +2973,22 @@ peter@localhost testdb=> <userinput>S+-------+--------+(4 rows)
+peter@localhost testdb=> <userinput>\pset border 3</userinput>
+Border style is 3.
+peter@localhost testdb=> <userinput>SELECT * FROM my_table;</userinput>
++-------+--------+
+| first | second |
++=======+========+
+|     1 | one    |
++-------+--------+
+|     2 | two    |
++-------+--------+
+|     3 | three  |
++-------+--------+
+|     4 | four   |
++-------+--------+
+(4 rows)
+peter@localhost testdb=> <userinput>\pset border 0</userinput>Border style is 0.peter@localhost testdb=>
<userinput>SELECT* FROM my_table;</userinput>
 

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.