On 10/05/2018 09:18 AM, Ravi Krishna wrote:
Hello, if you need to use COPY command from remote machine and you use
some libpq bindings (aka ruby pg gem for example), you can use functions
associated with COPY command
(https://www.postgresql.org/docs/10/static/libpq-copy.html). They should
be provided by bindings of postgres library you're using.
If you can share more info, at least how do you access postgres (via Ruby
gem for example or from client's console), I can try to be more descriptive.
We not writing any Ruby/Python code. We are using Datastage. Datastage
has in built features for most of the stuff. For example to bulk load data
from csv files
into Oracle/DB2 etc, it has a BULK loader feature. However DS has no
support for PG directly and we are piggy backing on ODBC where there is no
BULK loader.
The only recourse for us is to type in SQL as DS allows user code.
Can you install the postgres client software (psql) on the client machine
and then have Datastage spawn "psql -c 'COPY ...'"?
--
Angular momentum makes the world go 'round.
