CMS Web Services - linux:database:postgresql

change_to_utf8_encoding

anonymous@undisclosed.example.com (Anonymous) — Thu, 22 Apr 2021 00:34:12 +0000

Change default encoding to UTF-8 References: * * NOTE: Never perform this work on a database that is being written to. For my example a DB used by a very busy instance of Zabbix. Verify current server encoding root@zabdb:~ # psql -U zabbix zabbix psql (11.9) Type "help" for help. zabbix=> SHOW SERVER_ENCODING; server_e…

import_with_copy

anonymous@undisclosed.example.com (Anonymous) — Fri, 14 Jun 2019 19:46:05 +0000

Using PostgreSQL. To export table data, perform the following command: sudo -u system_user psql -d database -c "\copy (SELECT * FROM table_name) to '/tmp/output_data.csv' (format csv, delimiter ',') " To import the data, use this command: sudo -u system_user psql -d database -c "\copy table_name FROM '/tmp/import_data.csv' (format csv, delimiter ',')"