[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