X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B5CA6475CA9 for ; Mon, 3 Feb 2003 05:41:25 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 267E3475BEC for ; Mon, 3 Feb 2003 05:41:25 -0500 (EST) Received: from klaster.net (pa190.krakow.cvx.ppp.tpnet.pl [213.76.36.190]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 9720A2B211; Mon, 3 Feb 2003 11:35:05 +0100 (CET) Message-ID: <3E3E4881.1010204@klaster.net> Date: Mon, 03 Feb 2003 11:46:25 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Bhuvan A Cc: pgsql-sql@postgresql.org Subject: Re: Format in psql References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/51 X-Sequence-Number: 11449 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 | > +--------------+--------------------------------------------------------+ > > If yes, how can i do this? I have gone through the manual page of psql but > such formatting information donot appear over there. So, hope to get some > details over here. A link would be enough. > man psql. Inside psql: \pset border 2 Regards, Tomasz Myrta