Hi guys,

During a pg_dump, does the extra_float_digits option only affect the 
COPY data, or could it possibly also affect column defaults, view 
definitions, etc?

Chris



Mon, 06 Oct 2003 13:48:08 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
extra_float_digits question
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> During a pg_dump, does the extra_float_digits option only affect the 
> COPY data, or could it possibly also affect column defaults, view 
> definitions, etc?

It applies to any output of a float4 or float8 value, so yeah it could
affect display of column defaults etc.  Is this bad?

			regards, tom lane

Mon, 06 Oct 2003 02:20:13 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: extra_float_digits question 
>>During a pg_dump, does the extra_float_digits option only affect the 
>>COPY data, or could it possibly also affect column defaults, view 
>>definitions, etc?
> 
> 
> It applies to any output of a float4 or float8 value, so yeah it could
> affect display of column defaults etc.  Is this bad?

No, it's OK.  I'm just writing a table structure dumping function for 
phpPgAdmin, and I was wondering if I need to bother with 
extra_float_digits just for the structure or not.

I guess I do.

Chris



Mon, 06 Oct 2003 14:41:20 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: extra_float_digits question