Re: Figure out nullability of query parameters

2025-06-27 Thread Greg Sabino Mullane
> > It would be really handy to know that `$1` is being used as a non nullable > value To push back in a different way, how exactly would this be useful? The system catalogs are the best place to get all the various information about a relation, including any and all constraints. Data type info

Re: Figure out nullability of query parameters

2025-06-27 Thread David G. Johnston
On Friday, June 27, 2025, Giacomo Cavalieri wrote: > > It would be really handy to know that `$1` is being used as a non nullable > value, while `$2` could actually be null. Can this already be achieve > today, or would there be a way to surface this kind of information for > query parameters in

Re: Figure out nullability of query parameters

2025-06-27 Thread Petr Kada
Hi, I have no idea how/if this is possible using the query protocol but I would try to parse the INSERT statement to get the table and columns names and then look up whether they are nullable in the information schema ( https://www.postgresql.org/docs/current/infoschema-columns.html) Petr On Fri,