Bulk Co;y into postgres from within an omis library

[Terence Young]

Hii,
I meant to say..

Can a list of data be imported into a jason object and then passed to an sql statement containing the copy command.

terry


Terence J. Young, DC

System Administrator

IT

(608) 280-2679

________________________________
From: Terence Young <terry.young at journeymhc.org>
Sent: Tuesday, May 31, 2022 2:19 PM
To: omnisdev-en at lists.omnis-dev.com <omnisdev-en at lists.omnis-dev.com>
Subject: Bulk Co;y into postgres from within an omis library

Hi,
Has anybody been successful in executing a bulk copy, via copy, into a postgres database from within an Omnis library.

Can a list of data be imported into a jason object an sql containing the copy command.

I currently have  large table that I import using ..

Drop indexes
drop logging on the table
import using an insert with 1000 rows of data
set loggin back on for the table
recreated the indexes

It is still very slow.

terry


Terence J. Young, DC

System Administrator

IT

(608) 280-2679

If you received this e-mail in error, please notify the sender, delete the e-mail, and do not use, disclose or store the information it contains. This e-mail and any attachments may contain confidential information, including records protected by WI Mental Health 51.30 and/or AODA federal confidentiality rules (42 CFR Part 2) - both prohibit you from making any further disclosure of this information unless further disclosure is expressly permitted by the written consent of the person to whom it pertains or as otherwise permitted by 51.30 or 42 CFR Part 2. A general authorization for the release of medical or other information is NOT sufficient for this purpose. Federal rules restrict any use of this information to criminally investigate or prosecute any alcohol or drug abuse client.