Thread: pg_dump: Exporting SQL and data for a schema ONLY??
Hello all - Does anyone know if there is a way to export a schema only using pg_dump (or otherwise)? For example, if I have a database "test" that contains three schemas "public", "schema1", and "schema2" - and I want to export the SQL to re-create the tables and the data for schema1 only - how would I do that? If I dump the test database, the schemas are mixed together and is very cumbersome to extract out just one. Any suggestions appreciated. Thanks... BGH
Brian Huber <brianghuber@yahoo.com> writes: > Does anyone know if there is a way to export a schema > only using pg_dump (or otherwise)? 7.3's pg_dump does not have this feature, but it is in 7.4. regards, tom lane
Have you ever try pg_dump database_name -s Cheers Anis WN ________________________________ 15 Mbytes Free Web-based and POP3 Sign up now: http://www.gawab.com
Sorry... I mean pg_dump database_name -t schema_name -s is for dumping the schema only (no data) Anis WN ________________________________ 15 Mbytes Free Web-based and POP3 Sign up now: http://www.gawab.com