Re: Fwd: compressed bits in sql table

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: SANDEEP GOURNENI <sandeepgourneni(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: compressed bits in sql table
Date: 2018-06-09 23:43:21
Message-ID: 60f803a8-8ae6-9f16-6d28-7558130ab16b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 06/09/2018 03:43 PM, SANDEEP GOURNENI wrote:
> Postgres version is 10.4
> field type is char(32).basically its a fee bit field.

Can you explain what you mean by 'fee bit'?

Also not sure why you need to deal with compressed bits, cannot you not
just pull or push a string from/into the field?

> it is related to my application.
>
> thanks,
> Sandeep
>
> On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 06/09/2018 02:40 PM, SANDEEP GOURNENI wrote:
> >
> > Hi all,
> >
> > How can we read compressed bits in postgres.In one of my table
> field  i
> > have compressed bits.how to read and write them in postgres using
> cobol
> > program.
>
> You are going to need to be more specific:
>
> 1) What version of Postgres?
>
> 2) What is the field type?
>
> 3) Are you referring to the TOAST table?
>
> >
> > Thanks,
> > Sandeep
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yinjie Lin 2018-06-11 08:24:50 Temporarily disable a role
Previous Message Ron 2018-06-09 23:29:54 Re: Fwd: compressed bits in sql table

Browse pgsql-general by date

  From Date Subject
Next Message Bo Peng 2018-06-10 01:55:01 Re: Service pgpool
Previous Message Ron 2018-06-09 23:29:54 Re: Fwd: compressed bits in sql table