You could always use SUBSTR(Name,x,y) AS xxx to control the size of the output and the heading.
Duane
-----Original Message-----
From: Vinay Jain [mailto:vinayjain@gmail.com]
Sent: Sunday, July 04, 2004 10:20 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Formatting Function..
Hi..
I am newbe in postgresql so please help me though the question may be
very easy to answer..
Is there any formatting function to get output with fix lengths..for
example my query is..
schema is:
Student
(name Varchar,
age integer);
select name, age from student;
the output is like this..
Name | Age
xyz | 22
I want this length of name to be of my choice...is it possible..& how..
thanks in advance
Regards
Vinay
--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)