In pgadmin, I selected a table from my production database I want to export. I right clicked and selected backup. I set the filename to devices.sql and selected plain as format. Then I clicked the backup button and it created a sql file on my computer. Now I want to import the contents of that table into my development database. So I run the psql utility and enter the following:
But it gives me this error:
SET SET SET SET SET SET SET SET SET psql:/Users/GuardDog/Documents/devices.sql:34: ERROR: relation "devices" already exists psql:/Users/GuardDog/Documents/devices.sql:37: ERROR: role "xtremek" does not exist psql:/Users/GuardDog/Documents/devices.sql:50: ERROR: relation "devices_id_seq" already exists psql:/Users/GuardDog/Documents/devices.sql:53: ERROR: role "xtremek" does not exist ALTER SEQUENCE setval -------- 2 (1 row) ALTER TABLE psql:/Users/GuardDog/Documents/devices.sql:101: ERROR: multiple primary keys for table "devices" are not allowed
I get quite a few errors here. How can I import the data from my production server to development server in pgadmin/PostgreSQL 9.1.2 ?