On Sat, 28 Jan 2006, Eric B. Ridge wrote:
> That's because you've used the wrong syntax.
>
> $ psql contacts -c "\dt" > xrms.tables
>
> This is why I suggested you read the psql man page.
Well, the man page installed shows the -c option is to specify one command,
but when I try that:
[rshepard@salmo ~]$ psql -c "\dt" > xrms.tables
psql: FATAL: database "rshepard" does not exist
That's why I tried specifying the database name.
> Likely, the output is buffered. Did you try quitting psql (via \q) before
> checking the contents of the file.
Yes.
> Dude, "pg_dump" is not a psql command, nor is it a SQL command. It's a
> command-line program. You run it from your shell:
>
> $ pg_dump --schema-only pg_dump > xrms-schema.dmp
[rshepard@salmo ~]$ pg_dump --schema-only pg_dump > xrms-schema.dmp
pg_dump: [archiver (db)] connection to database "pg_dump" failed: FATAL:
database "pg_dump" does not exist
However, as the pg_dump man page specifies, the database name needs to be
listed on the coammand line. So,
$ pg_dump -s contacts > xrms.tables
works just fine.
I'm still curious why I cannot do this within psql.
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