Best way to calculate row size with pg_getline?

Mark Stosberg <mark-WmyhgDpj2fCHT8/[email protected]>
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
I'm trying to determine the best value to use with pg_getline for the
"size" value. The docs say:

"The second argument is the size of the variable: this should be greater
than the expected size of the row. "

I have a table with many columns including several "text" fields. I'm
not sure how to calculate a row size that would be good to use here.
Suggestions?

I'm hoping there might be an "auto" option, which would just calculate
the length of the row as it passes through, and raise the value if needed.

I'm used to the land of Perl, where it generally doesn't care how big my
content is before I stuff into a variable.

   Mark
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.