pandas over PostgreSQL needs COLLATE and pg_table_is_visible

[amotl]

About

pg_table_is_visible is needed by pandas when using its to_sql primitive to talk to CrateDB's PostgreSQL server interface.

References

• Resolve skipped tests: Needs COLLATE and pg_table_is_visible pyveci/sqlalchemy-postgresql-relaxed#33
• Add pg_table_is_visible scalar, for Django and psql compatibility crate#7988

[amotl]

pg_table_is_visible is available since CrateDB 5.8.

• Add pg_table_is_visible scalar, for Django and psql compatibility crate#7988 (comment)