Re: Case insensitive query on existing data

Thanks a lot Michael . Concurrent index building solves my problem of building index without locking. Best Regards, Saurav On Thu, Aug 13, 2020 at 10:45 PM Michael Lewis wrote: > create index concurrently lower( jsonb->>'name' ), drop old_index > concurrently, ensure that where/on/group by

Re: Fwd: changing password pgagent service account

On 8/13/20 10:19 AM, Henry Francisco Garcia Cortez wrote: Good morning I need to help I installed pgagent but I want to change password pgagent service account r5w83.png To me it looks like you are creating an account rather then changing a password. Also looks like it might be failing on

Fwd: changing password pgagent service account

Good morning I need to help I installed pgagent but I want to change password pgagent service account [image: r5w83.png] -- Ing. Henry G. Cortez

Re: Case insensitive query on existing data

create index concurrently lower( jsonb->>'name' ), drop old_index concurrently, ensure that where/on/group by conditions use lower( jsonb->>'name' ), then take lunch. What's your concern with this process? >

Re: hash joins are causing no space left error

On Wed, Aug 12, 2020 at 5:52 PM Ayub M wrote: > > This is PostgreSQL 11 on AWS, there is a mview query in this OLAP > database, the tables involved are huge - 50-100m records on average records > hundreds of columns in most cases. > How many tables and how many partitions each? Can you share an

Re: Bytea Example

On Thursday, August 13, 2020, Naveen Kumar 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

Re: How to export query results to excel file using psql command in postgresql

Hi Naveen, > On 13. Aug, 2020, at 16:10, Naveen Kumar wrote: > > How to export query results to excel file using psql command in postgresql use the "copy" command along with its CSV output setting. Then open the CSV file with Excel. Look here:

Re: How to export query results to excel file using psql command in postgresql

Hi čt 13. 8. 2020 v 16:10 odesílatel Naveen Kumar napsal: > How to export query results to excel file using psql command in postgresql > Excel can import csv file so you can for Postgres 12 \pset format csv \o path_to_file select * from ... or for older postgres \copy (select * from ...)

Re: How to export query results to excel file using psql command in postgresql

On 8/13/20 7:10 AM, Naveen Kumar wrote: How to export query results to excel file using psql command in postgresql You can't. You can export to CSV that you could then import into Excel. See: https://www.postgresql.org/docs/12/app-psql.html \copy -- Adrian Klaver adrian.kla...@aklaver.com

How to export query results to excel file using psql command in postgresql

How to export query results to excel file using psql command in postgresql

Re: Bytea Example

On 8/13/20 6:56 AM, Naveen Kumar wrote: I am not using any programming language. I am simply using PostgreSQL 12 version that's all I'm having a hard time figuring out how you are migrating from Oracle to Postgres without using at least SQL and some sort of driver to pull out of one and push

Re: Bytea Example

I am not using any programming language. I am simply using PostgreSQL 12 version that's all On Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver wrote: > On 8/13/20 6:49 AM, Naveen Kumar wrote: > > I am trying to migrate the database from Oracle to PostgreSQL > > The question was: > > What programming

Re: Bytea Example

On 8/13/20 6:49 AM, Naveen Kumar wrote: I am trying to migrate the database from Oracle to PostgreSQL The question was: What programming language and database driver are you using? On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver > wrote: On 8/13/20

Re: Bytea Example

I am trying to migrate the database from Oracle to PostgreSQL On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver wrote: > On 8/13/20 6:40 AM, Naveen Kumar 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

Re: Bytea Example

On 8/13/20 6:40 AM, Naveen Kumar 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? What programming language and database driver are you using? -- Adrian Klaver adrian.kla...@aklaver.com

Bytea Example

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?

Case insensitive query on existing data

Hi All, We use PostgreSQL JSONB storage. One of the keys in the JSON will be always have a "name" key. We want to perform case insensitive query on the name key. Our application is already live so we have some data and have existing indexes on the name key. I understand that one of the ways

Implement a new data type

Hello I would like to implement a new data type next to char, number, varchar... for example a special "Money" type, but I don't want to use extensions and the Create type command. I want to implement it directly inside source code, because I want to implement my new type at lower level, in