On 09/06/2014 10:34 AM, Abelard Hoffman wrote:
On Sat, Sep 6, 2014 at 7:28 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote:
On 09/06/2014 12:32 AM, Abelard Hoffman wrote:
[snip]
So, my question is, what's the simplest way to generate tab-escaped
TSV-formatted rep
Vinayak writes:
> The pg_catalog.concat() is defined as STABLE function.
> why was STABLE preferred for concat() over IMMUTABLE?
concat() invokes datatype output functions, which are not necessarily
immutable. An easy example is that timestamptz_out's results depend
on the TimeZone setting.
On Sat, Sep 6, 2014 at 7:28 AM, Adrian Klaver
wrote:
> On 09/06/2014 12:32 AM, Abelard Hoffman wrote:
[snip]
> So, my question is, what's the simplest way to generate tab-escaped
>> TSV-formatted reports with the first line containing the list of column
>> names?
>>
>>
>
> create table tsv_test
On 09/06/2014 12:32 AM, Abelard Hoffman wrote:
Hi.
Traditionally, to generate a TSV report, I've simply invoked psql with:
--no-align --field-separator '\t' --pset footer=off
That works in most cases, except when your column values contain tabs
themselves.
I know that COPY() will escape tabs (
Abelard Hoffman wrote on 06.09.2014 09:32:
Traditionally, to generate a TSV report, I've simply invoked psql
with: --no-align --field-separator '\t' --pset footer=off
That works in most cases, except when your column values contain tabs
themselves.
I know that COPY() will escape tabs (as \t), a
Hi.
Traditionally, to generate a TSV report, I've simply invoked psql with:
--no-align --field-separator '\t' --pset footer=off
That works in most cases, except when your column values contain tabs
themselves.
I know that COPY() will escape tabs (as \t), and we can use that from psql
with the \c
