On Sat, 30 Mar 2024, 10:04 Alexander Farber,
wrote:
> Thank you, Justin -
>
> On Sat, Mar 30, 2024 at 4:33 AM Justin Clift
> wrote:
>
>> On 2024-03-30 05:53, Alexander Farber wrote:
>> > I use the following postgresql.conf in my Dockerfile
>> > ( the full version at https://stackoverflow.com/a/7
ltiple statements.
> "
>
> >
> > Will it be better if we break the process into batches of like 10,000
> > rows & insert the data in its individual transactions? Or any other
> > better solution available ?
> >
> > On Sat, Mar 9, 2024 at 9:01 PM hect
myview TO 'some_dump_file'
Regards
Hector Vass
07773 352559
On Sat, Mar 9, 2024 at 4:01 PM kuldeep singh
wrote:
> Copy may not work in our scenario since we need to join data from multiple
> tables & then convert it to json using row_to_json . This json data
> eventually nee
On Sat, Mar 9, 2024 at 3:02 PM kuldeep singh
wrote:
> Hi,
>
> We are inserting data close to 1M record & having a single Jsonb column
> but query is getting stuck.
>
> We are using insert into select * .. , so all the operations are within
> the DB.
>
> If we are running select query individually
On Sat, Mar 9, 2024 at 12:18 PM omkar narkar
wrote:
> Hello Team,
>
> I am trying to upgrade my edb 10.5 community version to postgres 15.6
> version and while doing this i am getting error regarding OIDS are not
> stable across Postgresql version (sys.callback_queue_table.user_data).
> Kindly he
On Fri, Mar 8, 2024 at 4:22 PM David Gauthier wrote:
> Here's the situation
>
> - The DB contains data for several projects.
> - The tables of the DB contain data for all projects (data is not
> partitioned on project name or anything like that)
> - The "project" identifier (table column) exi
On Tue, 16 Jan 2024, 17:21 Ron Johnson, wrote:
> Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a
> different name (while also referring to it by the original name).
>
> We have an application running on DB2/UDB which (for reasons wholly
> unknown to me, and probably also
ttrelid) from pg_attribute where attrelid=
't2'::regclass and attnum>0) , json_agg(t) from t2 t;
Regards
Hector Vass
07773 352559
On Tue, Nov 28, 2023 at 12:12 PM Dominique Devienne
wrote:
> Hi. I've got a nice little POC using PostgreSQL to implement a REST API
> server
Not equivalent to the use of NOT ARRAY and entirely possible I have
misunderstood the requirement ...do you have some more test cases the non
array solution does not work for
Regards
Hector Vass
07773 352559
On Mon, Nov 27, 2023 at 9:29 AM Dominique Devienne
wrote:
> On Sat, Nov 25, 2023 a
(
select
test_id
from stuff a
inner join (values ('x'),('y'),('z'),('t')) b (v) using(v)
group by 1
)b on(a.id=b.test_id);
Regards
Hector Vass
On Sat, Nov 25, 2023 at 4:08 PM Tom Lane wrote:
> Andreas Joseph Krogh writes:
> > -- This work
like databases Aurora and MySQL ...
Not to say someone somewhere hasn’t but a claimed strength of Postgresql is
probably a hindrance in this instance.
Hector Vass
Data Engineer
07773 352559
On Fri, 12 Aug 2022, 11:24 Scott Simpson, wrote:
> Hi,
>
> I need to migrate many PostgreSQL Stored P
11 matches
Mail list logo
