Re: Suggestion to reduce COPY command output to csv file

2020-03-04 Thread David G. Johnston
On Wed, Mar 4, 2020 at 11:39 AM postggen2020 s wrote: > Hi Team, > Thanks a lot all of you, for providing support peoples like me. > Could you please provide a suggestion on COPY command. > > Environment: > DB Version:9.5.15 > postgis: > Table contain GIS data. > > I have a table with GIS data, i

Re: Suggestion to reduce COPY command output to csv file

2020-03-04 Thread Adrian Klaver
On 3/4/20 10:38 AM, postggen2020 s wrote: Hi Team, Thanks a lot all of you, for providing support peoples like me. Could you please provide a suggestion on COPY command. Environment: DB Version:9.5.15 postgis: Table contain GIS data. I have a table with GIS data, its around 300MB and 2Lacks+ rec

Suggestion to reduce COPY command output to csv file

2020-03-04 Thread postggen2020 s
Hi Team, Thanks a lot all of you, for providing support peoples like me. Could you please provide a suggestion on COPY command. Environment: DB Version:9.5.15 postgis: Table contain GIS data. I have a table with GIS data, its around 300MB and 2Lacks+ records. I want to export all the records to t