c/driver/postgresql: remove Redshift support

[lidavidm]

What feature or improvement would you like to see?

There's a dedicated Redshift driver available through dbc/ADBC Driver Foundry now, so it may be reasonable to drop the rudimentary Redshift support in this driver to clean up the code.

[lidavidm]

CC @Mandukhai-Alimaa