On Tue, Dec 1, 2020 at 10:16:31AM -0800, Jeff Davis wrote: > On Thu, 2020-10-08 at 23:17 -0400, Bruce Momjian wrote: > > As I said before, it is more raw bytes, but > > we > > don't have an SQL data type for that. > > Sorry to jump in to this thread late. > > Can't we just set both "filename" and "content" to be BYTEA, but then > set the format code to 1 (indicating binary)? > > For clients that do look at the descriptor, they are more likely to get > it right; and for clients that don't look at the descriptor, there will > be no change.
Yes, we could, but I thought the format code was not something we set at this level. Looking at byteasend() it is true it just sends the bytes. -- Bruce Momjian <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee