Re: [HACKERS] [SQL] How would I get rid of trailing blank line?

2009-04-02 Thread Tom Lane
Tena Sakai tsa...@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

Re: [HACKERS] [SQL] How would I get rid of trailing blank line?

2009-04-02 Thread Tena Sakai
Hi Tom, I am a bit surprised to hear that that '\n' is there unconditionally. But I am sure there are more pressing things for you to work on. It's something I can live with. Regards, Tena Sakai tsa...@gallo.ucsf.edu -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us]

Re: [HACKERS] [SQL] How would I get rid of trailing blank line?

2009-04-02 Thread Andrew Dunstan
Tom Lane wrote: Tena Sakai tsa...@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

Re: [HACKERS] [SQL] How would I get rid of trailing blank line?

2009-04-02 Thread Tena Sakai
...@gallo.ucsf.edu -Original Message- From: Andrew Dunstan [mailto:and...@dunslane.net] Sent: Thu 4/2/2009 6:34 PM To: Tom Lane Cc: Tena Sakai; pgsql-...@postgresql.org; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] [SQL] How would I get rid of trailing blank line? Tom Lane wrote: Tena