Excuse me how to realize the image in the postgresql data such as data types of access?

CodePudding user response:

My personal approach is, if the image is not big, can be stored in the database, in flow way if the image is larger, can be saved in files in server, database stores only the relevant information, as for the specific access, flow the way many on the net, the same, the database is common,

CodePudding user response:

A BLOB field

CodePudding user response:

refer to the original poster jazzlvzz response:

could you please tell me how to realize the image in the postgresql data such as data types of access?

I use bytea in PostgreSQL, oid type fields, to use the routine use of the Internet error flow way, want to give your routines, PostgreSQL, if you want to preserve what type of field use in flow defined?
There are no blob fields in postgresql,
Use PostgreSQL own lo_import function can realize the oid type such as read, write,