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

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 %

But to select all tables from a specific schema, you can use the -n switch:

pg_dump -n myschema  ...

Check out pg_dump's documentation (Joshua has already posted the link)

Thomas