Search code examples
postgresqldevexpressdevextreme

DevExpress not showing PostgreSQL foreign tables

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?

Solution

  • 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.