Neha Sharma writes:
> I am getting the below error while restoring data having foreign key
> constraint.
> [edb@localhost bin]$ ./createdb test1
> [edb@localhost bin]$ ./pg_restore -d test1 -c -e a.dump
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error
Hi,
I am getting the below error while restoring data having foreign key
constraint.
./psql postgres
psql (10beta2)
Type "help" for help.
postgres=# create user test;
CREATE ROLE
postgres=# create schema test;
CREATE SCHEMA
postgres=# grant all on SCHEMA test to test;
GRANT
postgres=# set search