search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

Implement IMPORT FOREIGN SCHEMA that supports Sybase #104

Closed GeoffMontee closed 6 years ago

GeoffMontee commented 8 years ago

Issue #75 is about implementing IMPORT FOREIGN SCHEMA for tds_fdw, but apparently, MS SQL Server and Sybase will require different implementations. The MS SQL Server implementation was covered by pull request #91. So far, the Sybase implementation has not been created.

ellmout commented 8 years ago

Hi,

Nice work, thx @select-artur !!!

But it doesn't work on my (very) old Sybase ASE 12.5, seems like it's stopping right after sending the query

SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'dbo'

Not trying the sysusers table.

I didn't get the difference between EXEC_FAILED and EXEC_FALSE...

And there is a mistake in the query that is getting the schema, after "sc.scale" and before the "FROM", there is a comma.

Thx for the hard work so far !

PS : Sorry for my english, i'm french :-)

za-arthur commented 8 years ago

Oh, ok. Thank you for testing. I'll investigate it.

za-arthur commented 7 years ago

Hi, I created the pull request #110 . I think it should work now :)

GeoffMontee commented 6 years ago

This PR was merged a while ago, so I'll go ahead and close this.