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

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:

  • Target tables: laboratorio.solicitantes
  • Target tables: "laboratorio"."solicitantes"

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:


1

Please sign in to leave a comment.