Hi Andrew, > Right. There's a simple pipeline way to get rid of it: > psql -t -f query.sql | sed -e '$d' > query.out
Hi Scott, > Tired of those blank lines in your text files? Grep them away: > psql -tf query.sql mydatabase | grep -v "^$" > query.out Thank you Both. Regards, Tena Sakai tsa...@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-sql@postgresql.org; pgsql-hack...@postgresql.org Subject: Re: [HACKERS] [SQL] How would I get rid of trailing blank line? 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 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