doganmeh <mehmet@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
