Upgrade to pgx 0.6.0

[JamesGuthrie]

Description

Merge requirements

Please take into account the following non-code changes that you may need to make with your PR:

• [ ] CHANGELOG entry for user-facing changes
• [ ] Updated the relevant documentation