Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting the Field Separator in PSQL - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Setting the Field Separator in PSQL
Date
Msg-id CAKFQuwa7dk5WUc9OPRuVTdxTmqv0TPRSFHKXpo1oGRr8V4xYXg@mail.gmail.com
Whole thread Raw
In response to Setting the Field Separator in PSQL  ("Osborn, Marty" <marty.osborn@rsa.com>)
Responses Re: Setting the Field Separator in PSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
On Tue, Apr 7, 2015 at 1:39 PM, Osborn, Marty <marty.osborn@rsa.com> wrote:

I need to change the field separator to a tab in an input SQL file.

 

I’ve tried every combination of tab, ‘\t’, “\t”, --field-separator=’\t’, etc, etc.

 

Should it be in the command line or in the SQL file?

Any help?



​More context would helpful but keep in mind that within SQL the expression:

'\t'  is a literal back-slash and a literal "t"

E'\t' is escaped to mean <tab>​

Dealing with the shell complicates the issue so if you can avoid it I suggest that do avoid it.

David J.

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Setting the Field Separator in PSQL
Next
From: "David G. Johnston"
Date:
Subject: Re: Setting the Field Separator in PSQL