Align `postgresDefault()` with other Postgres libraries

[krlmlr]

Do we want to respect libpq and psql defaults in postgresDefault() for alignment with other libraries? How do the Python, Go, Rust, Node, Julia clients do this?