psql-dump-handler
Installation
npm install psql-dump-handler -g
Name
psqlDumpHandler - PostgreSQL dump handler
Synopsis
psqlDumpHandler [COMMAND] [DATABASE NAME] [OPTIONS]...
Description
[COMMAND]:
dump (make a dump with only insert statements)
[DATABASE NAME]
databaseName, -d databaseName, --database=databaseName
[OPTIONS]:
-s, --sort (sort the statements by id ascending)
After running the command in the terminal a dump.sql file will be created at your current path..
NOTE:
1. This module expect you to have "node" command in /usr/bin/node.
2. This module currently only supports sorting dump file from PostgreSQL.
Why?
When the database dump your data, it might be unsorted just like the example below.
-- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.3 SET statement_timeout = 0;SET lock_timeout = 0;SET client_encoding = 'UTF8';SET standard_conforming_strings = on;SET check_function_bodies = false;SET client_min_messages = warning;SET row_security = off; SET search_path = public, pg_catalog; -- -- Data for Name: group; Type: TABLE DATA; Schema: public; Owner: makjacobsen -- INSERT INTO "group" (id, name) VALUES (2, "Admin");INSERT INTO "group" (id, name) VALUES (1, "Super Admin"); -- -- Name: group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: makjacobsen -- SELECT pg_catalog.setval('group_id_seq', 2, true);
When you use -s option you will get:
-- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.3 SET statement_timeout = 0;SET lock_timeout = 0;SET client_encoding = 'UTF8';SET standard_conforming_strings = on;SET check_function_bodies = false;SET client_min_messages = warning;SET row_security = off; SET search_path = public, pg_catalog; -- -- Data for Name: group; Type: TABLE DATA; Schema: public; Owner: makjacobsen -- INSERT INTO "group" (id, name) VALUES (1, "Super Admin");INSERT INTO "group" (id, name) VALUES (2, "Admin"); -- -- Name: group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: makjacobsen -- SELECT pg_catalog.setval('group_id_seq', 2, true);
License
MIT