CODEWITHSUNDEEP
sql-serverpostgresqllinked-server
marman
marman

Reputation: 437

Calling a SQL Server stored procedure from postgres

Is there any way to call a remote stored procedure on SQL Server from postgres ?

I need to call a stored procedure that receive 3 parameters and make an insert on a remote SQL Server database, if this is possible how can I know if the query was OK or if it was an error during the insert, because both tables on databases need to have the same info.

Upvotes: 0

Views: 2181

Answers (1)

jordani
jordani

Reputation: 436

http://www.postgresql.org/docs/9.0/static/contrib-dblink-connect.html

Upvotes: 1

Related Questions