You have 2 primary options for data types, BLOBs and stringlikes. For info on using the stringlike types, see here in the postgres documentation. For BLOBs, you'll actually end up using postgres utility functions to store the data in a system table, and you'll store a reference (called an oid) to it there in your normal table(s). I recently went through this, and learned how to do it. You can read up on it, and grab some code fragments, here. The solution was here. Also, check up on the Pg manpage -- it can be helpful.