agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedHow would I get rid of trailing blank line?
9+ messages / 7 participants
[nested] [flat]
* How would I get rid of trailing blank line?
@ 2009-04-02 21:33 Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 5 replies; 9+ messages in thread
From: Tena Sakai @ 2009-04-02 21:33 UTC (permalink / raw)
To: pgsql-sql
Hi Everybody,
I am using postgres 8.3.4 on linux.
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?
Thank you for your help.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2009-04-02 23:01 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
4 siblings, 2 replies; 9+ messages in thread
From: Tom Lane @ 2009-04-02 23:01 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-sql; pgsql-hackers@postgresql.org
"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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2009-04-03 01:20 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 9+ messages in thread
From: Tena Sakai @ 2009-04-03 01:20 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql; pgsql-hackers@postgresql.org
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
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thu 4/2/2009 4:01 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org
Subject: 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] How would I get rid of trailing blank line?
@ 2009-04-03 01:34 Andrew Dunstan <andrew@dunslane.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 9+ messages in thread
From: Andrew Dunstan @ 2009-04-03 01:34 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-sql; pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2009-04-03 02:53 Scott Marlowe <scott.marlowe@gmail.com>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
4 siblings, 0 replies; 9+ messages in thread
From: Scott Marlowe @ 2009-04-03 02:53 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-sql
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:
> 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?
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
>
--
When fascism comes to America, it will be the intolerant selling it as
diversity.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [HACKERS] How would I get rid of trailing blank line?
@ 2009-04-03 05:52 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Andrew Dunstan <andrew@dunslane.net>
0 siblings, 0 replies; 9+ messages in thread
From: Tena Sakai @ 2009-04-03 05:52 UTC (permalink / raw)
To: Andrew Dunstan <andrew@dunslane.net>; Tom Lane <tgl@sss.pgh.pa.us>; scott.marlowe@gmail.com; +Cc: pgsql-sql; pgsql-hackers@postgresql.org
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
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Andrew Dunstan [mailto:andrew@dunslane.net]
Sent: Thu 4/2/2009 6:34 PM
To: Tom Lane
Cc: Tena Sakai; pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [SQL] How would I get rid of trailing blank line?
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2009-04-06 02:21 Greg Sabino Mullane <greg@turnstep.com>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
4 siblings, 0 replies; 9+ messages in thread
From: Greg Sabino Mullane @ 2009-04-06 02:21 UTC (permalink / raw)
To: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> 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?
Now that my presenation on psql is over :), I'll share my solution:
psql -AX -qt -c "SELECT ..." | perl -pe 's/^\n// if $.<2'
This strips a newline from the first line only of the output, and
only if the line consists of nothing else. Highly recommended
for cron.
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200904052221
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAknZZ0YACgkQvJuQZxSWSsiDAwCglJS9/juQLe8asY3sG9fagbeo
2V4An0p5U6UHGI1KXoe2qQvURX5E5BZo
=Yy0J
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2009-04-10 15:09 Jasen Betts <jasen@xnet.co.nz>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
4 siblings, 0 replies; 9+ messages in thread
From: Jasen Betts @ 2009-04-10 15:09 UTC (permalink / raw)
To: pgsql-sql
On 2009-04-02, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> I am using postgres 8.3.4 on linux.
> 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?
I ask postgres to format it for me instead of relying on psql
psql db_name -c "copy (select * from foo ) to stdout;"
this gives me postgres style tab separated values, but I can
have CSV (or any otther format COPY can do) if I want.
I usually use a more complex subquery with a list of columns and
expressions, where, order by clauses, etc... )
I use this in a script that pulls data from one database and inserts
in into another.
Requires postgres 8.2 or later
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How would I get rid of trailing blank line?
@ 2015-11-15 02:17 david.paulo <david.paulo@legalfirst.com.au>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
4 siblings, 0 replies; 9+ messages in thread
From: david.paulo @ 2015-11-15 02:17 UTC (permalink / raw)
To: pgsql-sql
The sed -e '$d' is nice but it has a downside - it will mask the return code
from psql in the case when there is an error
--
View this message in context: http://postgresql.nabble.com/How-would-I-get-rid-of-trailing-blank-line-tp2153908p5873931.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2015-11-15 02:17 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-02 21:33 How would I get rid of trailing blank line? Tena Sakai <tsakai@gallo.ucsf.edu>
2009-04-02 23:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-04-03 01:20 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2009-04-03 01:34 ` Andrew Dunstan <andrew@dunslane.net>
2009-04-03 05:52 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2009-04-03 02:53 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-04-06 02:21 ` Greg Sabino Mullane <greg@turnstep.com>
2009-04-10 15:09 ` Jasen Betts <jasen@xnet.co.nz>
2015-11-15 02:17 ` david.paulo <david.paulo@legalfirst.com.au>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox