| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Osborn, Marty" <marty(dot)osborn(at)rsa(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Setting the Field Separator in PSQL |
| Date: | 2015-04-07 21:48:40 |
| Message-ID: | CAKFQuwa7dk5WUc9OPRuVTdxTmqv0TPRSFHKXpo1oGRr8V4xYXg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, Apr 7, 2015 at 1:39 PM, Osborn, Marty <marty(dot)osborn(at)rsa(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2015-04-07 21:52:23 | Re: Setting the Field Separator in PSQL |
| Previous Message | Adrian Klaver | 2015-04-07 21:36:22 | Re: Setting the Field Separator in PSQL |