how to get and put pdf in bytea (postgres)
only using sql and sql-command
0)main table to store binary file below
prototype=# \d storedpdf
Table "public.storedpdf"
col name | type | description |
---|---|---|
id | integer | key |
name | character varying | file name |
bytea | to store files |
1)create temporary table
prototype=# create table media(val text);
2)copy hex text stream to table(text)
cat /test/get.pdf | xxd -p | tr -d '\n' | psql -d prototype -c "\COPY media(val) FROM STDIN"
3)convert text to binary by decode function
prototype=# insert into storedpdf(pdf) select decode(val,'hex') from media;
psql -d prototype -c "\COPY (select pdf from storedpdf ) TO STDOUT" | xxd -r -p>get.pdf