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

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