Hi, I have a par of questions.
1) I've read alot abot the 8K row limitation on pgsql. What would happen if I
had a table defined with two columns, one serial and the other TEXT, and in
one insert the texct that goes in the column with type TEXT has 80K or even
more?
2) Is it posible to storag
Hello all.
I'm developer in Java with JDBC2.0.
How can I stora a binary (byte []) (such a certificate X.509,
request of certificate, etc).
Can I use the Type String (I think that not)?
Should I use LOB?
Thanks a lot. Gabi.
Hi,
Am I correct in impression that the only way you can store binary data
(meaning data that could have all control characters including \0 in it)
is using Large Objects interface? I have tried bytea and text, both
truncate string on receipt of \0...
Also, what's physical storage size of a LOB?
Hi,
can Postgres store binary data in TEXT fields? Or is there a solution
except large objects?
Dirk
