Re: Bytea Example - Mailing list pgsql-general

From David G. Johnston
Subject Re: Bytea Example
Date
Msg-id CAKFQuwaV2MBNFVO8j1a1Ke5RvC9VNAPeWy3Xh4XbSwOzdGW3sg@mail.gmail.com
Whole thread Raw
In response to Bytea Example  (Naveen Kumar <naveenmcp@gmail.com>)
List pgsql-general
On Thursday, August 13, 2020, Naveen Kumar <naveenmcp@gmail.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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to export query results to excel file using psql command in postgresql
Next
From: Michael Lewis
Date:
Subject: Re: hash joins are causing no space left error