Postgres Pro
Downloads
Home   >   mailing lists

Re: copy ... from stdin csv; and bytea - Mailing list pgsql-general

From Tom Lane
Subject Re: copy ... from stdin csv; and bytea
Date
Msg-id 24156.1217227862@sss.pgh.pa.us
Whole thread Raw
In response to Re: copy ... from stdin csv; and bytea  (Klint Gore <kgore4@une.edu.au>)
Responses Re: copy ... from stdin csv; and bytea
List pgsql-general
Tree view 
Klint Gore <kgore4@une.edu.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

pgsql-general by date:

Previous
From: Klint Gore
Date:
Subject: Re: copy ... from stdin csv; and bytea
Next
From: Yi Zhao
Date:
Subject: why my postgresql auto crashed???