Skip to content

Instantly share code, notes, and snippets.

@openrijal

openrijal/pgsql specific

Created July 7, 2015 13:08
Show Gist options
  • Save openrijal/dbcf99729a43d86e7af8 to your computer and use it in GitHub Desktop.
Save openrijal/dbcf99729a43d86e7af8 to your computer and use it in GitHub Desktop.
Download ZIP
Django Related
Raw
pgsql specific
# to import data from csv to table
\copy <table_name> from '/path/to/csv/filename.csv' DELIMITERS ',' CSV;
# to increase the auto_increment after import
ALTER SEQUENCE tblName_id_seq RESTART WITH <number>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment