doganmeh <meh...@edgle.com> writes:
> I tried varchar(12) also, nothing changed. My questions is 1) I have
> 672x12=8,064 characters in the first row (which are actually the headers),
> why would it complain that it is 8760.
No, you have 672*13, because each varchar value will require a length
word (which is only 1 byte for short values like these). Adding the
24-byte row header comes to 8760.
> 2) Is there anything I can do to work
> around this situation?
Maybe you could combine the strings into an array? A large array would
be subject to compression and/or out-of-line storage, but 12-byte fields
are too small to benefit from either.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
