From: | Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)gov> |
---|---|
To: | "'Vinay Jain'" <vinayjain(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Formatting Function.. |
Date: | 2004-07-06 16:09:32 |
Message-ID: | 64EDC403A1417B4299488BAE87CA7CBF01CD0EB1@maricopa_xcng0 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com]
Sent: Sunday, July 04, 2004 10:20 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Seymour | 2004-07-06 16:11:28 | Re: Do we need more emphasis on backup? |
Previous Message | Bruce Momjian | 2004-07-06 16:04:05 | Re: Do we need more emphasis on backup? |