X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 522EA475925 for ; Mon, 3 Feb 2003 05:51:35 -0500 (EST) Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3]) by postgresql.org (Postfix) with ESMTP id 2562A475843 for ; Mon, 3 Feb 2003 05:51:34 -0500 (EST) Received: from [62.165.4.177] (helo=kidman.akademie1.de) by lubitsch.akademie.de with esmtp (Exim 3.33 #2) id 18feCN-0006yl-00; Mon, 03 Feb 2003 11:51:35 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: Bhuvan A , pgsql-sql@postgresql.org Subject: Re: Format in psql Date: Mon, 3 Feb 2003 11:50:28 +0100 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Message-Id: <200302031150.28945.barwick@gmx.net> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/52 X-Sequence-Number: 11450 On Monday 03 February 2003 11:54, Bhuvan A wrote: > Hi, > > I am using pgsql-7.2.3. Can i able to format the output of a SELECT sql in > psql as perl format? > > Something like, > +--------------+--------------------------------------------------------+ > | work_desc_id | short_desc | > +--------------+--------------------------------------------------------+ > | 1 | Short description line 1 | > | > | | Short description line 2 | > | | Short description line 3 | > | | Short description line n | > +--------------+--------------------------------------------------------+ 'fraid I don't understand what you mean by "perl" format. You can get format in the style above by executing \pset border 2 in psql. (SQL*Plus fans should issue=20 \pset border 0 and recompile psql without readline support to simulate an Oracle environment ;-) Place this setting in your .psqlrc file to make it permanent. Ian Barwick barwick@gmx.net =20