I need to capture the schema on a postgres database and recreate it on another ansi compliant platform. Is it possible to generate a file (perhaps from pg_dump?) as a sequence of ansi compliant SQL commands which can be used to recreate the structure?
Thanks in advance!