Maintaining blank lines in psql output? - Mailing list pgsql-general

From Ron
Subject Maintaining blank lines in psql output?
Date
Msg-id 04db9247-4452-e9bb-e64a-1545e04d37bc@gmail.com
Whole thread Raw
Responses Re: Maintaining blank lines in psql output?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
White space can of course make things easy to read, but psql seems to ignore 
those blank lines.  Is there any way to retain them in psql output?

$ cat spaces.sql
insert into foo values(1);
insert into foo values(2);
insert into foo values(3);
insert into foo values(4);


insert into bar values(1);
insert into bar values(2);
insert into bar values(3);
insert into bar values(4);


insert into snaggle values(1);
insert into snaggle values(2);
insert into snaggle values(3);
insert into snaggle values(4);


insert into frob values(1);
insert into frob values(2);
insert into frob values(3);
insert into frob values(4);


postgres@haggis:~$ psql12 test -af spaces.sql
insert into foo values(1);
INSERT 0 1
insert into foo values(2);
INSERT 0 1
insert into foo values(3);
INSERT 0 1
insert into foo values(4);
INSERT 0 1
insert into bar values(1);
INSERT 0 1
insert into bar values(2);
INSERT 0 1
insert into bar values(3);
INSERT 0 1
insert into bar values(4);
INSERT 0 1
insert into snaggle values(1);
INSERT 0 1
insert into snaggle values(2);
INSERT 0 1
insert into snaggle values(3);
INSERT 0 1
insert into snaggle values(4);
INSERT 0 1
insert into frob values(1);
INSERT 0 1
insert into frob values(2);
INSERT 0 1
insert into frob values(3);
INSERT 0 1
insert into frob values(4);
INSERT 0 1


-- 
Born in Arizona, moved to Babylonia.



pgsql-general by date:

Previous
From: Wiwwo Staff
Date:
Subject: Re: Tablespace OID, database OID, relfilenode
Next
From: "David G. Johnston"
Date:
Subject: Re: Maintaining blank lines in psql output?