Foreign tables do not appear in intellisense cues

[atalarczyk]

Describe the bug

When writing SQL queries, foreign tables do not appear in intellisense cues.

To Reproduce

Steps to reproduce the behavior:

1. Open a connection to a database with foreign tables.
2. Start writing SELECT * FROM
3. Press Ctrl+SPACE
4. Names of foreign tables are missing from the list.

Expected behavior

Names of foreign tables should appear in the list so that they can be added to the query.

Screenshots

VS Code version

Version: 1.106.3 (user setup)
Commit: bf9252a2fb45be6893dd8870c0bf37e2e1766d61
Date: 2025-11-25T22:28:18.024Z (2 wks ago)
Electron: 37.7.0
ElectronBuildId: 12781156
Chromium: 138.0.7204.251
Node.js: 22.20.0
V8: 13.8.258.32-electron.0
OS: Windows_NT x64 10.0.26200

Extension Logs

[8:53:31 PM] Connecting to server "" on document "untitled:Untitled-1".
[8:53:31 PM] Connected to server "REDACTED>" on document "untitled:Untitled-1". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"16.0.11"}

I would check whether, when getting object names from pg_catalog.pg_class, the tables are not limited to relkind = 'r' while relkind = 'f' should be used, too.

[mmcfarland]

Hi @atalarczyk, we applied a fix in v1.16. Can you validate and let us know if your foreign tables are provided in intellisense results?

[atalarczyk]

I'm sorry to disappoint you but foreign tables still don't appear in the intellisense. Tested on v1.18.

[mmcfarland]

Thanks for the update -- I've reopened the issue and will continue to investigate.

[atalarczyk]

I appreciate it. If I could be of any assistance, I'd be happy to help.

[mmcfarland]

Hi @atalarczyk -- I'm testing this out on some FDW tables and getting the expected results in v1.18.0

I set it up using the FDW extension. Is there a different mechansim for creating these foreign tables that I may not be testing for?

CREATE EXTENSION postgres_fdw;
   
....
   
   CREATE FOREIGN TABLE foreign_test_table (
     id integer,
     name text
   ) SERVER loopback_server
     OPTIONS (schema_name 'public', table_name 'some_existing_table');

[mmcfarland]

Hi @atalarczyk, we've taken another pass at this in v1.19.0 (pre-release). Could you give it another try and let us know if foreign tables are showing up in IntelliSense now? If not, I'd love to know the steps you use to create the foreign tables so I can reproduce.