perl - Archiving text log files in postgresql -

we writing testing framework scratch using perl. each test case writes log file , planning archive resulting log files created each test case reporting purposes.

now using postgresql database storing results. how archive text log file in postgresql database? googled , found out bytea datatype can used store files in binary format. if how retrieve text?.

any ideas appreciated.

if log files text files, should use text datatype store them. if log files binary (or, perhaps, compressed text files), you'd want use bytea. in either case, can insert , select them other column type when using dbi. if they're large might want play longreadlen dbi parameter , read dbi manual section on blobs.