Tom Lane <tgl@xxxxxxxxxxxxx> writes:
> If you have the dump in a text file you could just edit it and remove
> that line (it's only about a dozen lines in, typically). Otherwise
> you could delete it with sed or the like, roughly
>
> pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '', false);//' | psql targetdb
Great, I can easily do that! I missed the "rewrite-dump-as-sql-script"
functionality of pg_restore.
Thanks a lot, also to Adrian!
bye, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
lele@xxxxxxxxxxxxxxx | -- Fortunato Depero, 1929.
