I'd like to know how to store a file a table and also which datatype is used for this? I'm using VC++ on windows and SQL ODBC API functions to connect to the database and get information. I have tried using the datatype "bytea" but this has a size limitation of 8190 characters. In MS Access and SQL 7.0 there are datatypes of type SQL_LONGVARBINARY. Is there a similar datatype in postgresql ?
Thanks.