DevExpress not showing PostgreSQL foreign tables-CodePudding

I'm trying to connect to PostgreSQL through DevExpress. The connection is returning the tables correctly except for the foreign tables.

Here's how I am connecting to PostgreSQL:

public DataConnectionParametersBase GetDataConnectionParameters(string name)
    {
            return new PostgreSqlConnectionParameters("xxx.xxx.xxx.xxx", XXXX, "dbName", "postgres_user", "XXXXXXXXX");
    }

This is working well and returning all tables. However, the foreign tables are not showing.

Any ideas, please?

CodePudding user response：

Try to trick your tool by using a VIEW on top of the foreign table:

CREATE VIEW x AS 
SELECT * FROM your_foreign_table;

Most likely DevExpress checks pg_class just for the standard tables and views and isn't aware of new types of objects like foreign tables. But that's just an assumption.