Skip site navigation (1) Skip section navigation (2)

Re: Help to dump tables in a database and restore in another database

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Help to dump tables in a database and restore in another database
Date: 2010-01-05 11:05:08
Message-ID: 264855a01001050305l4127ddcboca5909a1560cb5c4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Jan 5, 2010 at 5:42 AM, Intengu Technologies
<sindile(dot)bidla(at)gmail(dot)com> wrote:
> Running Windows7 with Postgresql 8.4
>
> I am trying to dump about 132 tables, this is my command:
>
> pg_dump --host localhost --port 5432 --username postgres -o -v -t
> 'myschema.*' dbname > mydump.sql
>
> This generates an error no matching tables were found, is the asterisk
> not a wild card meaning all tables found in the schema named myschema

You probably want to use the '-n' argument to specify the schema name
directly.  See the documentation for pg_dump.

> When restoring the tables from the dump will i still have the 132
> tables or 1 table

The database tables will be dumped as is, so you will have pretty much
a copy of your original data (132 tables, if that is the correct
number).

> Your valued advise is appreciated.
>
>
> 2009/10/18 Andreas Kretschmer <akretschmer(at)spamfence(dot)net>:
>> Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:
>>
>>> On Fri, Oct 16, 2009 at 09:38:44AM +0200, Intengu Technologies wrote:
>>> > I would like to dump a number of tables from a database and load them
>>> > on another database. How do I accomplish this.
>>>
>>> pg_dump makes this easy. Documentation is here:
>>> http://www.postgresql.org/docs/8.4/static/app-pgdump.html
>>
>> Right, additionally, pg_dump has options to specify only destined
>> tables, views, sequence, schemas etc. to dump.
>>
>>
>> Andreas
>> --
>> Really, I'm not out to destroy Microsoft. That will just be a completely
>> unintentional side effect.                              (Linus Torvalds)
>> "If I was god, I would recompile penguin with --enable-fly."   (unknown)
>> Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>
>
>
> --
> Sindile Bidla
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

pgsql-novice by date

Next:From: Peter JacksonDate: 2010-01-05 13:56:30
Subject: Using a variable in sql in a function
Previous:From: Thomas KellererDate: 2010-01-05 10:50:15
Subject: Re: Help to dump tables in a database and restore in another database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group