Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Unanswered: Backup DB partially

    Hi,


    My DB contains more than 700 tables, out of these i want to take backup of tables for particular organisation.Here, my aim is to take backup of a few tables with "where org= ?" condition and the rest in full.Is this possible in postgresql?? Please provide me with possible solution.

    Thanks in Advance!!

    ~suhail

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by suhailck View Post
    My DB contains more than 700 tables, out of these i want to take backup of tables for particular organisation.Here, my aim is to take backup of a few tables with "where org= ?" condition and the rest in full. Is this possible in postgresql
    The only solution I can think of, is to create views that contain your condition and then only export those views using pg_dump

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •