I have tried running the pg_dump command with the following flag:

--exclude-table-data foo_bar

However it seems this flag is ignored completely if the public schema does not contain a foo_bar table. In my case foo_bar only exists for tenant schemas. Is there an undocumented function to achieve this?

  • 1
    A shot in the dark. Did you try: %.foobar? – a_horse_with_no_name Oct 6 '16 at 9:54
  • @a_horse_with_no_name yes, doesn't affect the result unfortunately – Hedde van der Heide Oct 6 '16 at 10:20

Thanks to @a_horse_with_no_name's comment I figured out the correct wildcard syntax

  • Please accept your answer, so that your question is marked as resolved – a_horse_with_no_name Jul 26 '19 at 5:23

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.