I'm working with a postgres database recovered from a dump, and there are some empty tables and foreign keys with null values. I'm suspecting the dump could be incomplete, because original database had these data from dblinks.

I couldn't find it in the documentation. When we do the pg_dump it dumps the data from dblinks?

  • 1
    Do you mean views referencing dblink in the from clause? – Colin 't Hart Jun 4 at 14:41
  • @Colin'tHart Yes. – Fábio Roberto Teodoro Jun 4 at 15:06
  • A foreign key can never point to a view, nor could the contents of a table depend on a view. – Laurenz Albe Jun 5 at 1:22

No, pg_dump won't dump data from views. Views don't store data: they're purely a definition of how to retrieve the data -- a stored select statment, if you will.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.