bash & postgres
| От | Greenhorn |
|---|---|
| Тема | bash & postgres |
| Дата | |
| Msg-id | ddcb1c340903222103o72859dem83d39222036b7ef8@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: bash & postgres
Re: [SQL] bash & postgres Re: bash & postgres |
| Список | pgsql-general |
Hi,
I'm trying to pass variables on a bash script embedded with psql commands.
cat header.txt
"to1","from1","subject1"
"to2","from2","subject2"
"to3","from3","subject3"
"to4","from4","subject4"
cat b.sh
#!/bin/bash
two="2"
psql -h localhost -U postgres -d mobile -c "create temp table header (
field_1 text not null,
field_2 text not null,
field_3 text not null
);
\\copy header FROM header.txt CSV
SELECT * FROM header limit "$two"; "
When I execute b.sh
================================
ERROR: syntax error at or near "\"
LINE 10: \copy header FROM header.txt CSV
^
How do I use \c (or any other psql commands beginning with a "\") in a
bash script?
Thanks.
В списке pgsql-general по дате отправления: