Perhaps creating a temporary table would be more efficient.
Then the rollback isn't necessary.
Yep, but only if you're sure that you don't have queries which change other parts of the database, including calling procedures which could change data or structure. That's why I like the fact that even DDLs are transactional in Postgres :)