Feature Request: Display Foreign Tables (fdw) in Database Navigator & IntelliSense Support

[ChandraSaiKarthik]

Summary: Add support for

• Displaying foreign tables in the database navigator/tree view for PostgreSQL (and other databases that support foreign tables).
• Enabling IntelliSense/autocomplete to recognize and suggest foreign table names in SQL editors.

Current Behavior:

• Foreign tables created via CREATE FOREIGN TABLE are not shown in the schema tree.
• Users can only query them manually using information_schema.foreign_tables or SQL.

Expected Behavior:

• Foreign tables should appear under the schema alongside regular tables, views, and materialized views.
• Ideally, they should have a distinct icon or label (e.g., “Foreign Table”) for easy identification.

Why This Is Important:

• Improves visibility and usability for users working with PostgreSQL FDW (Foreign Data Wrapper) or similar features.
• Reduces reliance on manual queries to discover foreign tables.
• Aligns with the goal of providing a complete schema representation in the UI.

[mikeburgh]

This has been added to 1.17.29, they will appear in the External Tables section.. which is consistent with other DB engines.

[ChandraSaiKarthik]

Unable to retrieve DDL for external tables

Thanks for adding this functionality. small issue while scripting them.