On Sat, 28 Jan 2006, Doug McNaught wrote:
You can either use 'pg_dump --schema-only' as another poster suggested, or use the '\o' command in psql.
When I try 'pg_dump --schema-only' I get a continuation prompt, even with a semicolon at the end of the command line. A second semicolon produces this: contacts=# pg_dump --schema-only; contacts-# ; ERROR: syntax error at or near "pg_dump" at character 1 LINE 1: pg_dump ^ If I use the \o command (with or without a file name) I get the command prompt and no results. Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863