tds_fdw icon indicating copy to clipboard operation
tds_fdw copied to clipboard

Implement IMPORT FOREIGN SCHEMA

Open GeoffMontee opened this issue 8 years ago • 8 comments

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/

GeoffMontee avatar Apr 27 '16 19:04 GeoffMontee

+1

This will be a great feature to have

isapir avatar May 31 '16 22:05 isapir

is anyone working on it?

denishpatel avatar Jun 04 '16 15:06 denishpatel

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

GeoffMontee avatar Jun 04 '16 16:06 GeoffMontee

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

GeoffMontee avatar Sep 02 '16 23:09 GeoffMontee

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

calebhearth avatar Sep 08 '16 14:09 calebhearth

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

GeoffMontee avatar Sep 08 '16 15:09 GeoffMontee

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

JesseAwhere avatar May 22 '17 22:05 JesseAwhere

Checked, the link was not working anymore.

juliogonzalez avatar May 22 '17 22:05 juliogonzalez

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)

mbanck avatar Oct 23 '23 09:10 mbanck

Thanks, @mbanck. I will close this one.

GeoffMontee avatar Oct 23 '23 12:10 GeoffMontee