Re: pg_restore -L reordering of the statements does not work

Thanks a lot Tom for the detailed info. Few queries -

1. Is there any way I can create my own list file?

2. For Alter table <<table name>> owner to <<role name>> statement, what is the equivalent line in the list file?

3. Was using List file to achieve the following, i.e. executing the following lines in this order -

* Restoring the dump file using list file with role <<user1>>

* create table schema1.table1

* grant all on schema1 to user2

* alter table schema1.table1 to user2

Is the above possible using list file, if not what is the best alternative as we would like to automate.

PS: Don't have super user privileges on the target.