Please include the list when replying.
On Tue, Nov 16, 2010 at 11:45 AM, Gary Fu 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 fa
On 11/15/10 21:10, Derrick Rice 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 g...@modular:~/sybase2postgres> psql -c "\\copy
Short answer: for simple commands, you can use shell-escaping of a
double-quoted string.
psql -c "\\copy \"Table\" from 'text file'"
Note: double \\ is intentional. You need to escape the backslash, which
normally escapes other special characters, like $ and ". Watch out for other
special charact
Hi,
How do I escape both " and ' to be used in the 'psql -c ' command ?
For example, how to make the psql command {\copy "Table" from
'txt_file'} to be used in the psql with -c option (psql -c) ?
The "Table" has to be double quoted here.
Thanks,
Gary
--
Sent via pgsql-general mailing list (pg
