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.

On Tue, Nov 16, 2010 at 11:45 AM, Gary Fu <gfu@sigmaspace.com> wrote:
Short answer: for simple commands, you can use shell-escaping of a
double-quoted string.

psql -c "\\copy \"Table\" from 'text file'"


This works on sh, but I tried this syntax on tcsh, it fails:

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 по дате отправления:

Предыдущее
От: Chris Barnes
Дата:
Сообщение: Re: I want to create a read only database for a specified user.
Следующее
От: Stephen Cook
Дата:
Сообщение: Re: Postgres forums ... take 2