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