Re: Formatting psql output

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk
Cc: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: Formatting psql output
Date: 2002-11-06 18:01:40
Message-ID: 20021106180140.GA14903@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 06, 2002 at 10:47:59 +0000,
markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk wrote:
> I'm sure I'm missing something obvious here, but how can I tell either
> the server or psql to limit the number of digits presented in a set of
> results? Is there a facility somewhere for applying something like a
> printf format string?

The to_char function can do this.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-06 18:04:06 Re: How to cast as numeric
Previous Message Charles H. Woloszynski 2002-11-06 17:41:19 Re: Synchronising/mirroring databases