I have a problem when accessing a db in postgreSQL.
On my server i have 2 databases. On the first i can access without problems.
On the second i receive this message when i try to create a remote view on its connection. When i create the connection i have no problems
The message is:
"The Remote View Wizard was unable to obtain column information for this remote table.
This may be the result of an ODBC error, or the remote table may not be owned by the current user. or the table doesn't have columns"

In this database i have one simple take with two fields and i am using the user postgres like the other db

Thanks