Skip to content

Instantly share code, notes, and snippets.

@silenius
Created February 12, 2015 10:29
Show Gist options
  • Save silenius/c7b642dd8e8ffce56be0 to your computer and use it in GitHub Desktop.
Save silenius/c7b642dd8e8ffce56be0 to your computer and use it in GitHub Desktop.
jcigar@dev:~/ > pg_restore -d alienalert -O -x -t country_id_seq -t country nb.sql
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 191; 1259 3251168 TABLE country jcigar
pg_restore: [archiver (db)] could not execute query: ERROR: relation "country_id_seq" does not exist
Command was: CREATE TABLE country (
id integer DEFAULT nextval('country_id_seq'::regclass) NOT NULL,
name character varying(200) ...
pg_restore: [archiver (db)] Error from TOC entry 3663; 0 3251168 TABLE DATA country jcigar
pg_restore: [archiver (db)] could not execute query: ERROR: relation "country" does not exist
Command was: COPY country (id, name, iso_code) FROM stdin;
WARNING: errors ignored on restore: 2
jcigar@dev:~/ > pg_restore -l nb.sql|grep -i 'country'
190; 1259 3251166 SEQUENCE public country_id_seq jcigar
191; 1259 3251168 TABLE public country jcigar
3663; 0 3251168 TABLE DATA public country jcigar
3703; 0 0 SEQUENCE SET public country_id_seq jcigar
3492; 2606 3251413 CONSTRAINT public pk_country jcigar
3484; 1259 3251436 INDEX public idx_eea_country_id jcigar
3493; 1259 3251445 INDEX public unique_country_iso_code jcigar
3494; 1259 3251446 INDEX public unique_country_name jcigar
3527; 2606 3251447 FK CONSTRAINT public fk_eea_country jcigar
3528; 2606 3251452 FK CONSTRAINT public fk_metzger_country jcigar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment