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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])