Call Proceduta Cross DB in Postgresql

Question

I want to call procedures cross databases in PostgreSql
I found dblink, but I'm trying to understand if it's also possible to call procedures with it
If not, how can it be done?

Frank Heikens · Accepted Answer · 2023-04-21 07:58:12Z

0

Yes, you can use db_link for this. You can execute any piece of SQL over db_link.

If you only need access to different tables on these external databases, you could use a foreign table as well. For this you have to install the postgres_fdw-extension.

answered Apr 21, 2023 at 7:58

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

El_L Over a year ago

what is the syntax

Collectives™ on Stack Overflow

Call Proceduta Cross DB in Postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related