Fix postgres metadata queries to be schema aware

Queries on information_schema catalog may result ambiguous rows if `table_schema`
is not defined.
Add support to search_path on connection