I am having an issue with postgres 7.3.4 and pg_restore.
I have a pg_dump archive that I made with the following command: pg_dump -p <port> -h <server> -Fc -Z9 -f db.dmp -v <db>
However, when I try to do a pg_restore for a specific table, it is not restoring the permission to the table. Is there a way to have pg_restore restore a specific table w/ the permissions?
Here was my restore command: pg_restore -Fc -v -p <port> -h <server> -d <db> -t <table> db.dmp
Thanks for any help,
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
