Inheriting column comments with an FDW

36 views Asked by At

I have 2 postgresql database instances and I use fdw to import schemas from one instance to another. However I've seen that my local column comments don't import with schemas. I know that inheritance doesn't preserve constraints, indexes and rights. But I wanted to know if there was a way to keep comments at column level.

I import my schemas like this:

import foreign schema nom_schema_local from server nom_server into nom_schema_distant ;

Thank you

0

There are 0 answers