Обсуждение: Re: [SQL] How would I get rid of trailing blank line?

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> I often use a line like:
>   psql -tf query.sql mydatabase > query.out

> -t option gets rid of the heading and count
> report at the bottom.  There is a blank line
> at the bottom, however.  Is there any way to
> have psql not give me that blank line?

Doesn't look like it --- the final fputc('\n', fout); seems to be
done unconditionally in all the output formats.  I wonder if we should
change that?  I'm afraid it might break programs that are used to it :-(
        regards, tom lane

<p><font size="2">Hi Tom,<br /><br /> I am a bit surprised to hear that that '\n'<br /> is there unconditionally.  But
Iam sure<br /> there are more pressing things for you to<br /> work on.  It's something I can live with.<br /><br />
Regards,<br/><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br /><br /><br /> -----Original Message-----<br /> From: Tom
Lane[<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]<br /> Sent: Thu 4/2/2009 4:01 PM<br /> To: Tena
Sakai<br/> Cc: pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org<br /> Subject: Re: [SQL] How would I get rid of
trailingblank line?<br /><br /> "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:<br /> > I often use a line
like:<br/> >   psql -tf query.sql mydatabase > query.out<br /><br /> > -t option gets rid of the heading and
count<br/> > report at the bottom.  There is a blank line<br /> > at the bottom, however.  Is there any way to<br
/>> have psql not give me that blank line?<br /><br /> Doesn't look like it --- the final fputc('\n', fout); seems
tobe<br /> done unconditionally in all the output formats.  I wonder if we should<br /> change that?  I'm afraid it
mightbreak programs that are used to it :-(<br /><br />                         regards, tom lane<br /><br /></font> 

Tom Lane wrote:
> "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
>   
>> I often use a line like:
>>   psql -tf query.sql mydatabase > query.out
>>     
>
>   
>> -t option gets rid of the heading and count
>> report at the bottom.  There is a blank line
>> at the bottom, however.  Is there any way to
>> have psql not give me that blank line?
>>     
>
> Doesn't look like it --- the final fputc('\n', fout); seems to be
> done unconditionally in all the output formats.  I wonder if we should
> change that?  I'm afraid it might break programs that are used to it :-(
>
>
>   

Right. There's a simple pipeline way to get rid of it:
   psql -t -f query.sql | sed -e '$d' > query.out


cheers

andrew

<p><font size="2">Hi Andrew,<br /><br /> > Right. There's a simple pipeline way to get rid of it:<br /> >   psql
-t-f query.sql | sed -e '$d' > query.out<br /><br /> Hi Scott,<br /><br /> > Tired of those blank lines in your
textfiles?  Grep them away:<br /> > psql -tf query.sql mydatabase | grep -v "^$" > query.out<br /><br /> Thank
youBoth.<br /><br /> Regards,<br /><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br /><br /><br /> -----Original
Message-----<br/> From: Andrew Dunstan [<a href="mailto:andrew@dunslane.net">mailto:andrew@dunslane.net</a>]<br />
Sent:Thu 4/2/2009 6:34 PM<br /> To: Tom Lane<br /> Cc: Tena Sakai; pgsql-sql@postgresql.org;
pgsql-hackers@postgresql.org<br/> Subject: Re: [HACKERS] [SQL] How would I get rid of trailing blank line?<br /><br
/><br/><br /> Tom Lane wrote:<br /> > "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:<br /> >  <br /> >>
Ioften use a line like:<br /> >>   psql -tf query.sql mydatabase > query.out<br /> >>    <br /> ><br
/>>  <br /> >> -t option gets rid of the heading and count<br /> >> report at the bottom.  There is a
blankline<br /> >> at the bottom, however.  Is there any way to<br /> >> have psql not give me that blank
line?<br/> >>    <br /> ><br /> > Doesn't look like it --- the final fputc('\n', fout); seems to be<br />
>done unconditionally in all the output formats.  I wonder if we should<br /> > change that?  I'm afraid it might
breakprograms that are used to it :-(<br /> ><br /> ><br /> >  <br /><br /> Right. There's a simple pipeline
wayto get rid of it:<br /><br />     psql -t -f query.sql | sed -e '$d' > query.out<br /><br /><br /> cheers<br
/><br/> andrew<br /><br /></font>