Re: psql and tab-delimited output - Mailing list pgsql-general

From Alban Hertroys
Subject Re: psql and tab-delimited output
Date
Msg-id FDB1BDDD-9039-4B3A-81D0-60C0C58E2FFC@gmail.com
Whole thread Raw
In response to Re: psql and tab-delimited output  (Abelard Hoffman <abelardhoffman@gmail.com>)
Responses Re: psql and tab-delimited output  (David G Johnston <david.g.johnston@gmail.com>)
Re: psql and tab-delimited output  (Abelard Hoffman <abelardhoffman@gmail.com>)
List pgsql-general
On 07 Sep 2014, at 10:45, Abelard Hoffman <abelardhoffman@gmail.com> wrote:

> For reports, everyone else mostly uses other tools? I'd like to stay away from GUI-tools, if possible.

For reporting, usually you use the data in the database directly.

A TSV or CSV file is not a report, it’s at best a data source for your report. Going through an intermediate format is
nota particularly effective approach to create reports, but if you have to (for example because you aren’t _allowed_
accessto the database), generally preferred formats seem to be CSV, XML or JSON; as long as it’s a standard format. 
TSV is not a common choice. Are you sure your boss actually cares that it’s TSV and not, for example, CSV?

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.



pgsql-general by date:

Previous
From: Abelard Hoffman
Date:
Subject: Re: psql and tab-delimited output
Next
From: David G Johnston
Date:
Subject: Re: psql and tab-delimited output