Support pq driver

[sebiwi]

I'm trying to scan a value into a currency.Amount variable using the pq driver. I'm getting the following error when doing so:

5:12PM ERR PostStore.UserPosts: sql: Scan error on column index 2, name "price": value is not a string: [40 48 46 48 48 48 48 48 44 69 85 82 41]

This comes from here: https://github.com/bojanz/currency/blob/master/amount.go#L365. I guess this is not supported? The documentation says this works with pgx (it does). It works fine for inserts too.

If it is not supported, could it be implemented? Maybe doing something like this: lib/pq#544 (comment).

Thanks!

[bojanz]

Happy to evaluate a PR that would add pq support!

Won't be working on one myself because pg is in maintenance mode and recommends users use pgx when possible.