zabbix-backup icon indicating copy to clipboard operation
zabbix-backup copied to clipboard

Published 20 hours ago • verified publisher icon maxhq

Add column names to INSERT INTO .. VALUES and quote names as needed

Open diffway opened this issue 3 years ago • 3 comments

diffway avatar Jul 02 '21 20:07 diffway

can you elaborate on why you suggest this, please?

ironbishop avatar Jul 03 '21 08:07 ironbishop

@ironbishop thanks for comment. INSERT commands (rather than COPY, which is the default for pg_dump) is more like logical backup, and its grep-able Off cause it is painfully slow on restore, but it can be useful in some cases. Consider the need to restore specific subset of data or export database in test environment with non-PostgreSQL DBMS.

diffway avatar Jul 22 '21 10:07 diffway

ok. i'll merge this in my fork, thanks. i also moved the options to the top together with the others.

ironbishop avatar Jul 23 '21 09:07 ironbishop