Re: keeping images in a bytea field on AWS RDS

2020-03-31 Thread Christophe Pettus
> On Mar 31, 2020, at 13:52, Ron wrote: > initdb is definitely not what you want to do just to load an image into an > exiting database. I think there may be some confusion on the OP's part because many sources give out *advice* to put a filesystem path, rather than the entire actual binary

Re: keeping images in a bytea field on AWS RDS

2020-03-31 Thread Ron
On 3/31/20 2:49 PM, Richard Bernstein wrote: I am using postgresql on RDS. I need to upload an image to the table. I understand that I need to set the PGDATA directory and place the image file in it, before setting the path in the bytea field. But how do I set PGDATA if I don't have the ability

Re: keeping images in a bytea field on AWS RDS

2020-03-31 Thread Alan Hodgson
On Tue, 2020-03-31 at 15:49 -0400, Richard Bernstein wrote: > I am using postgresql on RDS. I need to upload an image to the table. > I understand that I need to set the PGDATA directory and place the > image file in it, before setting the path in the bytea field. But how > do I set PGDATA if I don

Re: keeping images in a bytea field on AWS RDS

2020-03-31 Thread Christophe Pettus
> On Mar 31, 2020, at 12:49, Richard Bernstein wrote: > > I am using postgresql on RDS. I need to upload an image to the table. I > understand that I need to set the PGDATA directory and place the image file > in it, before setting the path in the bytea field. But how do I set PGDATA if > I

keeping images in a bytea field on AWS RDS

2020-03-31 Thread Richard Bernstein
I am using postgresql on RDS. I need to upload an image to the table. I understand that I need to set the PGDATA directory and place the image file in it, before setting the path in the bytea field. But how do I set PGDATA if I don't have the ability to set an environment variable, and don't have a