Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

creating foreign table, doesn't import two fields #49

Open
luiggicc opened this issue Jan 16, 2017 · 0 comments
Open

creating foreign table, doesn't import two fields #49

luiggicc opened this issue Jan 16, 2017 · 0 comments

Comments

@luiggicc
Copy link

I have been working with PostgreSQL again and i'm doing a communication between sql server 2005 and PostgreSQL 9.6. I used the Foreign Data Wrapper odbc_fdw.

I created with no problem like 11 foreign tables. But the last one, when i create imports all fields, but there's two fields that doesn't show the data. One is varchar type and the other is int type.

My query fixed to 3 fields only to show:

create foreign table nathalia.m_itinerario(
MRN varchar(100),
dep_temporal varchar(8) NULL,
Sec_itinerario int NULL
)
server sqlserver2005
options(database 'Nathalia', schema 'dbo', sql_query 'select * from m_itinerario');

The fields MRN and Sec_itinerario sends me the data Null and dced me from the postgres server.

Any idea why?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant