On Jun 21, 2011, at 15:43, Scott Frankel wrote: > Is there a way to pipe text into a COPY statement's stdin input using > cmd-line psql?
cat myfile | psql -c "COPY mytable (name, description, text) FROM stdin" > - The db is password protected, so invoking `psql` as a non-interactive > command may not be possible. Right? Use a .pgpass file Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
