pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcompressed bits in sql table
6+ messages / 3 participants
[nested] [flat]
* compressed bits in sql table
@ 2018-06-09 21:36 SANDEEP GOURNENI <sandeepgourneni@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: SANDEEP GOURNENI @ 2018-06-09 21:36 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks,
Sandeep
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fwd: compressed bits in sql table
@ 2018-06-09 21:40 SANDEEP GOURNENI <sandeepgourneni@gmail.com>
parent: SANDEEP GOURNENI <sandeepgourneni@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: SANDEEP GOURNENI @ 2018-06-09 21:40 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; pgsql-general@lists.postgresql.org; pgsql-admin
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.
Thanks,
Sandeep
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: compressed bits in sql table
@ 2018-06-09 22:34 Adrian Klaver <adrian.klaver@aklaver.com>
parent: SANDEEP GOURNENI <sandeepgourneni@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Adrian Klaver @ 2018-06-09 22:34 UTC (permalink / raw)
To: SANDEEP GOURNENI <sandeepgourneni@gmail.com>; pgsql-admin@lists.postgresql.org; pgsql-general@lists.postgresql.org; pgsql-admin
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.klaver@aklaver.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: compressed bits in sql table
@ 2018-06-09 22:43 SANDEEP GOURNENI <sandeepgourneni@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 6+ messages in thread
From: SANDEEP GOURNENI @ 2018-06-09 22:43 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-admin@lists.postgresql.org; pgsql-admin; pgsql-general@lists.postgresql.org
Postgres version is 10.4
field type is char(32).basically its a fee bit field.
it is related to my application.
thanks,
Sandeep
On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: compressed bits in sql table
@ 2018-06-09 23:29 Ron <ronljohnsonjr@gmail.com>
parent: SANDEEP GOURNENI <sandeepgourneni@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Ron @ 2018-06-09 23:29 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Are you asking how to SELECT ... WHERE based on individual bits in this
CHAR(32) field?
How were the bits encoded in the first place?
On 06/09/2018 05:43 PM, SANDEEP GOURNENI wrote:
> Postgres version is 10.4
> field type is char(32).basically its a fee bit field.
> it is related to my application.
>
> thanks,
> Sandeep
>
> On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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?
>
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: compressed bits in sql table
@ 2018-06-09 23:43 Adrian Klaver <adrian.klaver@aklaver.com>
parent: SANDEEP GOURNENI <sandeepgourneni@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2018-06-09 23:43 UTC (permalink / raw)
To: SANDEEP GOURNENI <sandeepgourneni@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org; pgsql-admin; pgsql-general@lists.postgresql.org
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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2018-06-09 23:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-06-09 21:36 compressed bits in sql table SANDEEP GOURNENI <sandeepgourneni@gmail.com>
2018-06-09 21:40 ` SANDEEP GOURNENI <sandeepgourneni@gmail.com>
2018-06-09 22:34 ` Adrian Klaver <adrian.klaver@aklaver.com>
2018-06-09 22:43 ` SANDEEP GOURNENI <sandeepgourneni@gmail.com>
2018-06-09 23:29 ` Ron <ronljohnsonjr@gmail.com>
2018-06-09 23:43 ` Adrian Klaver <adrian.klaver@aklaver.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox