Re: psql -F - Mailing list pgsql-sql

From T E Schmitz
Subject Re: psql -F
Date
Msg-id 455C8563.9030207@numerixtechnology.de
Whole thread Raw
In response to Re: psql -F  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Joe Conway wrote:
> T E Schmitz wrote:
> 
>> Alvaro Herrera wrote:
>>
>>> T E Schmitz wrote:
>>>
>>>> I have written a shell script to export data:
>>>>
>>>> psql -A -t -U $DBUSER -d $DB -c "$QUERY" -F ' '
>>>>
>>>> How can I specify a TAB character with the -F option?
> 
> Try:
>    psql -A -t -U $DBUSER -d $DB -c "$QUERY" -F $'\t'

You're a star - that does the trick!


Regards,

Tarlika Elisabeth Schmitz


pgsql-sql by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: recursive SQL and with clause
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Apoie o estudo das células tronco