Setting the Field Separator in PSQL

From: "Osborn, Marty" <marty(dot)osborn(at)rsa(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Setting the Field Separator in PSQL
Date: 2015-04-07 20:39:07
Message-ID: 8CB6E5A8E0D688459585A6F52093BC250EBE18@MX104CL02.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Marty
________________________________
[cid:image001(dot)jpg(at)01D07148(dot)FA5AC0E0], The Security Division of EMC
Information Security Services Group

[CISSP]

Marty Osborn, CISSP, RSA CSP
Principal Practice Consultant 214-676-9571
marty(dot)osborn(at)rsasecurity(dot)com<mailto:marty(dot)osborn(at)rsasecurity(dot)com>

________________________________
This message contains information that may be confidential and privileged. Unless you are the addressee (or authorized to receive mail for the addressee), you should not use, copy, or disclose to anyone this message or any information contained in this message. If you have received this message in error, please so advise the sender by reply e-mail and delete this message. Thank you for your cooperation.
________________________________

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jim Nasby 2015-04-07 21:31:35 Re: [SQL] check data for datatype
Previous Message Gerardo Herzig 2015-04-07 16:59:46 Re: check data for datatype