Tables do not appear in Items sidebar

[aaronsharff]

1. PostgreSQL 15.3
2. TablePlus Version 6.0.0 (550)

3. Issue:

   • No tables appear in sidebar

   • (SELECT table_name, table_schema, table_type FROM information_schema.tables) UNION (SELECT c.relname AS table_name, n.nspname AS table_schema, 'MATERIALIZED VIEW' FROM pg_catalog.pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'm'); returns results as expected

   • Refreshing TablePlus does not fix the issue

   • Only one schema available in schema dropdown

[huyphams]

Hi @aaronsharff are you sure that the public schema has items?

[aaronsharff]

Hi @aaronsharff are you sure that the public schema has items?

Yes, table_schema = 'public' has items

[huyphams]

We use this query to get the item list, can you run it and show me the result?

SELECT table_name, table_schema, table_type FROM information_schema.tables WHERE table_schema='schema_name'

SELECT table_name, table_schema, table_type FROM information_schema.tables WHERE table_schema='public'

[aaronsharff]

[huyphams]

So it is redshift and not PostgreSQL driver?

[aaronsharff]

Yes, thank you, that's my mistake. For posterity, I had chosen a "Redshift" connection but it was actually a Postgres database. All good here now.

[huyphams]

Thanks, redshift has a different structure so you should use the correct driver. Closing this issue for now.