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.
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 |