[Info-ingres] COPY command support
pwhite peercore
pwhite at peercore.com.au
Tue Mar 8 23:39:12 UTC 2016
Hi Saumya,
What operating system are you running?
The copy statement was working fine in Ingres 2.0
Please try running copydb from the operating system command prompt.
copydb mydb mytable
or
copydb -c mydb mytable
This generates two files copy.in and copy.out which you then use to import
and export data from the database.
Both copy.in and copy.out contain examples of the copy statement.
See simple example here:
http://en.allexperts.com/q/Ingres-3317/Ingres-flat-files-unix.htm
Paul
-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of saumya
saxena
Sent: Wednesday, 9 March 2016 12:56 AM
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] COPY command support
Hi experts,
I'm using ingresdbi2.0 for executing queries. I have a requirement of
executing COPY command to dump the table data to flat file. But found there
is no support for it, please advice what can be done for it ?
Thanks,
Saumya
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres
More information about the Info-ingres
mailing list