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 #75

Closed GeoffMontee closed 1 year ago

GeoffMontee commented 8 years ago

PostgreSQL 9.5 adds IMPORT FOREIGN SCHEMA, but this is not yet implemented in tds_fdw.

http://www.postgresql.org/docs/9.5/static/sql-importforeignschema.html

http://blog.2ndquadrant.com/postgresql-9-5-import-foreign-schema/

isapir commented 8 years ago

+1

This will be a great feature to have

denishpatel commented 8 years ago

is anyone working on it?

GeoffMontee commented 8 years ago

Not at the moment. If anyone else would like to try implementing it, pull requests would be most welcome.

GeoffMontee commented 8 years ago

@select-artur contributed a patch that implements IMPORT FOREIGN SCHEMA. It has been merged into master if anyone would like to test it.

calebhearth commented 8 years ago

@GeoffMontee I was able to import my (extensive) schema yesterday. I didn't get to verify everything but it looked pretty good.

GeoffMontee commented 8 years ago

Awesome! I'm glad to hear that it seemed to work pretty well for you, @calebthompson.

JesseAwhere commented 7 years ago

Please remove the second link in your initial comment. That site is compromised and it has a big scareware fake infected PC page.

juliogonzalez commented 7 years ago

Checked, the link was not working anymore.

mbanck commented 1 year ago

Should this issue not be closed as IMPORT FOREIGN SERVER has been implemented for a long time, or are there still loose ends (missing Sybase support? Though I think that was also added https://github.com/tds-fdw/tds_fdw/commit/f062f963ef86ce7d1e76b9387645daab0d4aa10f)

GeoffMontee commented 1 year ago

Thanks, @mbanck. I will close this one.