| From: | "Deole, Pushkar (Pushkar)" <pdeole(at)avaya(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Regarding bytea column in Posgresql |
| Date: | 2015-04-09 11:03:30 |
| Message-ID: | 78A4D6BFBAA5BA49A5E94DA00A6A76E353DF1D@AZ-FFEXMB04.global.avaya.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have been assigned to a product that uses Postgresql 9.3 as backend database. I am new to postgresql.
The product provides chat functionality between the uses and the completed chats are stored in the database table in a 'bytea' column in the form of xml. When I query the data from this column I see xml file with text data. I have couple of queries:
1. Is 'bytea' column intended for storing text data?
2. Typically a chat can have text data with several special characters (which can be represented in multi bytes), how these characters can be stored in a bytea column and retrieved back properly?
Thanks,
Pushkar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2015-04-09 11:10:16 | Re: Regarding bytea column in Posgresql |
| Previous Message | dlefebvre | 2015-04-09 10:00:50 | Cannot connect from local network to my postgresql server |