0.1.2 • Published 8 years ago
psql-dump-handler v0.1.2
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