I want to INSERT binary data (blob) purely with SQL statements without using files.
In Oracle, it seems that it can be realized in hexadecimal notation as described in this article .
INSERT INTO BLOB_MEDIA (CONTENT_ID, MEDIA) VALUES ( 1, HEXTORAW('3E00210102CDA000C9') )
What should I do with PostgreSQL and SQL Server?
In SQL Server,
binary values can be written in hexadecimal with
0x without quotes, such as