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