Maintaining blank lines in psql output?

Поиск
Список
Период
Сортировка
От Ron
Тема Maintaining blank lines in psql output?
Дата
Msg-id 04db9247-4452-e9bb-e64a-1545e04d37bc@gmail.com
обсуждение исходный текст
Ответы Re: Maintaining blank lines in psql output?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Wiwwo Staff
Дата:
Сообщение: Re: Tablespace OID, database OID, relfilenode
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Maintaining blank lines in psql output?