Re: copy ... from stdin csv; and bytea

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Klint Gore <kgore4(at)une(dot)edu(dot)au>
Cc: David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: copy ... from stdin csv; and bytea
Date: 2008-07-28 06:51:02
Message-ID: 24156.1217227862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Klint Gore <kgore4(at)une(dot)edu(dot)au> writes:
> David Wilson wrote:
>> I'm not certain how to check the actual byte width of a column within a
>> row,

> select length(bytea_field) from table

If you want the actual on-disk footprint, use pg_column_size()

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yi Zhao 2008-07-28 07:02:47 why my postgresql auto crashed???
Previous Message Klint Gore 2008-07-28 06:10:44 Re: copy ... from stdin csv; and bytea