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
orpg_ctl -D /usr/local/pgsql/data initdb
initdb is definitely not what you want to do just to load an image into an exiting database.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
