Postgres Pro
Downloads
Home   >   mailing lists

Re: escape character for 'psql -c ' command - Mailing list pgsql-general

From Derrick Rice
Subject Re: escape character for 'psql -c ' command
Date
Msg-id AANLkTim-59e3JMyeL3nXOZF7YcTRU_3R-nfrf+n13uVD@mail.gmail.com
Whole thread Raw
In response to Re: escape character for 'psql -c ' command  (Gary Fu <gfu@sigmaspace.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Chris Barnes
Date:
Subject: Re: I want to create a read only database for a specified user.
Next
From: Stephen Cook
Date:
Subject: Re: Postgres forums ... take 2