CODEWITHSUNDEEP
postgresqldevexpressdevextreme
user7441202
user7441202

Reputation:

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?

Upvotes: 0

Views: 85

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127222

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.

Upvotes: 0

Related Questions