Foreign Key between different databases

Question

Foreign Key between different databases

Navigation

#1 by (0 votes)

5

Is it possible to link between two different databases in one Migration? I'm using Postgres.

What I have:

$table->integer('id_cliente_produto')->unsigned();
$table->foreign('id_cliente_produto')->references('id_cliente_produto')->on('clienteproduto');

I need something like:

$table->integer('id_cliente_produto')->unsigned();
$table>foreign('id_cliente_produto')>references('id_cliente_produto')->on('Banco2.tabela');

postgresql laravel

asked by anonymous 27.06.2016 / 20:10

1 answer

What is the difference between declaring variables using let and var? Curl php is not working [closed]

score 0 · Answer 1

I never needed to do this, but giving a google search I found this solution (I did not test to see if it works):

$table>foreign('id_cliente_produto')>references('id_cliente_produto')->on(new Illuminate\Database\Query\Expression('Banco2.tabela'));

Recommendation: Put the reference to the bank name in some configuration file, in case the name of the bank changes, you only have to change one file.