extra_float_digits question

Started by Christopher Kings-Lynneover 22 years ago3 messageshackers
Jump to latest
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: 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

#3Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Tom Lane (#2)
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