Re: escape character for 'psql -c ' command
| От | Derrick Rice |
|---|---|
| Тема | Re: escape character for 'psql -c ' command |
| Дата | |
| Msg-id | AANLkTim-59e3JMyeL3nXOZF7YcTRU_3R-nfrf+n13uVD@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: escape character for 'psql -c ' command (Gary Fu <gfu@sigmaspace.com>) |
| Список | pgsql-general |
Please include the list when replying.
Consult your shell's documentation.
http://www.tcsh.org/tcsh.html/Lexical_structure.html
http://www.tcsh.org/tcsh.html/Special_shell_variables.html#backslash_quote
Apparently you can use "set backslash_quote=1" and then the original will work. Read the warning above about backslash_quote:
Or use the long-version, which is pretty reliable.
Derrick
On Tue, Nov 16, 2010 at 11:45 AM, Gary Fu <gfu@sigmaspace.com> wrote:
This works on sh, but I tried this syntax on tcsh, it fails:Short answer: for simple commands, you can use shell-escaping of a
double-quoted string.
psql -c "\\copy \"Table\" from 'text file'"
11:38am 72 gfu@modular:~/sybase2postgres> psql -c "\\copy \"Table\" from 'text file'"
Unmatched ".
How to make it work on tcsh ?
Consult your shell's documentation.
http://www.tcsh.org/tcsh.html/Lexical_structure.html
http://www.tcsh.org/tcsh.html/Special_shell_variables.html#backslash_quote
Apparently you can use "set backslash_quote=1" and then the original will work. Read the warning above about backslash_quote:
Or use the long-version, which is pretty reliable.
Derrick
В списке pgsql-general по дате отправления: