My setup: Postgresql (9.4)
On my database, I have various schemata, beside 'public', for example 'reference'. Whenever, I want to generate DDL of a table in 'public' (for example here, 'adressebuch'), I got:
-- auto-generated definition
create table adressebuch
adresse_id serial not null
references tbl_adresse_typ (id)
and have to correct the reference from 'tbl_adresse_typ' to 'reference.tbl_adresse_typ', because the referenced table is in another schema. The code is now then usable to deploy to another server.
My question is, whether there is an option to have this correct generated, or could it be, that I missed some settings?
PS: For testing, you can use Flyway and the sql files at my repo: https://github.com/gipfeli/KProject/tree/master/SQL_Flyway
Thank you and have a nice day.