Postgres Pro
Downloads
Home   >   mailing lists

Re: Help to dump tables in a database and restore in another database - Mailing list pgsql-novice

From Tom Lane
Subject Re: Help to dump tables in a database and restore in another database
Date
Msg-id 10067.1262975524@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help to dump tables in a database and restore in another database  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-novice
Tree view 
Thomas Kellerer <spam_eater@gmx.net> writes:
> Intengu Technologies, 05.01.2010 11:42:
>> 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

> No. The wildcard character in SQL is %

pg_dump's wildcard is * though.

            regards, tom lane

pgsql-novice by date:

Previous
From: Matthew Kirk
Date:
Subject: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)
Next
From: Tom Lane
Date:
Subject: Re: upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)