Thanks for the report,
I've commented out amcanorder for 9.6 here:
https://github.com/pgjdbc/pgjdbc/pull/560
Does anybody know what is the proper way to tell if index column is ASC or
DESC in 9.6+?
pgjdbc used something like
CASE pg_am.amcanorder
WHEN true THEN CASE pg_index.indoption[(pg_index.keys).n - 1] & 1
WHEN 1 THEN 'D'
ELSE 'A'
END
ELSE NULL
END AS ASC_OR_DESC,
Vladimir