| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Naveen Kumar <naveenmcp(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Bytea Example |
| Date: | 2020-08-13 14:19:22 |
| Message-ID: | CAKFQuwaV2MBNFVO8j1a1Ke5RvC9VNAPeWy3Xh4XbSwOzdGW3sg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, August 13, 2020, Naveen Kumar <naveenmcp(at)gmail(dot)com> wrote:
> Can someone please give me an example on byteA data type.
>
> 1. How to import a image/text file into Bytea data type.?
> 2. How to export the same?
>
At a simple level its no different than importing and exporting character
data using a “text/varchar” field or a number using an integer field. For
bytea the content is just raw bytes instead of characters or numbers.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henry Francisco Garcia Cortez | 2020-08-13 17:07:53 | changing password pgagent service account |
| Previous Message | Adrian Klaver | 2020-08-13 14:15:38 | Re: How to export query results to excel file using psql command in postgresql |