keeping images in a bytea field on AWS RDS

From: Richard Bernstein <richb201(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: keeping images in a bytea field on AWS RDS
Date: 2020-03-31 19:49:11
Message-ID: CAKXm1c3nJZLMZ8BNN7Aa+cB2mXED1BC2T-D-hePnMZToHh-NKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
access to the following on an AWS controlled installation?

$ initdb -D /usr/local/pgsql/data or

pg_ctl -D /usr/local/pgsql/data initdb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-03-31 19:51:48 Re: keeping images in a bytea field on AWS RDS
Previous Message Tom Lane 2020-03-31 19:18:22 Re: Index selection issues with RLS using expressions