DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=w5OUdxAqCSCa9/RJtY7Q1iiHkD8e/C7k7JF6iM21+iXc0yyLfEHhV4QblWGZwg8H4p
	xhOq5nJaIHjqbz/LttzxZCkrEeqd5Q9Ef7EhrSUgv3h+nTqJ7XQj5W0iZ3tLt1YMxZNN
	+ngJ/4LnRBV6Lugzm1pBRBckCQlds00oLRuFY=
MIME-Version: 1.0
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84A65@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84A65@egcrc-ex01.egcrc.org>
Date: Thu, 2 Apr 2009 20:53:37 -0600
Message-ID: <dcc563d10904021953v53412679qdfdc8ba29589a098@mail.gmail.com>
Subject: Re: How would I get rid of trailing blank line?
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Apr 2, 2009 at 3:33 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Everybody,
>
> I am using postgres 8.3.4 on linux.
> I often use a line like:
> =A0 psql -tf query.sql mydatabase > query.out
>
> -t option gets rid of the heading and count
> report at the bottom.=A0 There is a blank line
> at the bottom, however.=A0 Is there any way to
> have psql not give me that blank line?

Tired of those blank lines in your text files?  Grep them away:

psql -tf query.sql mydatabase | grep -v "^$" > query.out


>
> Thank you for your help.
>
> Regards,
>
> Tena Sakai
> tsakai@gallo.ucsf.edu
>


--=20
When fascism comes to America, it will be the intolerant selling it as
diversity.