Re: \COPY in script
От | Tom Lane |
---|---|
Тема | Re: \COPY in script |
Дата | |
Msg-id | 15509.1475861368@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | \COPY in script (Binand Sethumadhavan <binand@gmx.net>) |
Ответы |
Re: \COPY in script
|
Список | pgsql-novice |
Binand Sethumadhavan <binand@gmx.net> writes: > I am trying to do a summary query in one DB, and populate a table in another. > This is how I'm doing it: > psql -h db1 -d d1 -U u1 -A -F, -t -f a.sql | psql -h db2 -d d2 -U u2 [...] > Now, this ellipsis is what is causing consternation. > 1. If the ellipsis is -c "$( < b.sql )" my target table gets populated. > 2. If the ellipsis is -f b.sql my target table does not get populated. > My b.sql is as follows: > \COPY table_name FROM STDIN CSV > That's it. Why does (1) work but (2) does not? I think you want "pstdin" not "stdin". See the description of \copy in the psql man page. regards, tom lane
В списке pgsql-novice по дате отправления: