How to create a foreign key in a non public schema. Follow

Created November 26, 2017 23:17

I want to create a foreign key in a schema called laboratorio from a table called procedencias to a table called solicitantes.

The problem is that I don't know where to write the name of my schema (laboratorio).

I think it should be in the Target table field but the autocomplete doesn't work for schema. Even I tried writing but doesn't work. I tried this:

But DataGrip can't find the schema.

The error is here: It should be "laboratorio"."solicitantes" (or laboratorio.solicitantes).

Even I tried with PHPStorm. It has the same problem:

Please sign in to leave a comment.