Maintaining blank lines in psql output?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Maintaining blank lines in psql output?
Date: 2023-01-17 20:48:40
Message-ID: 04db9247-4452-e9bb-e64a-1545e04d37bc@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-01-17 21:22:22 Re: Maintaining blank lines in psql output?
Previous Message Wiwwo Staff 2023-01-17 19:49:45 Re: Tablespace OID, database OID, relfilenode