Syntax for Postgres command

[Dan Ridinger]

Hello Das,

If I remember correctly, you cannot execute COPY via execute direct. I think I had to use execute it from the command line style like ‘psql COPY ….’  or something similar.

It has been a long while since I have done this. It may be different now.


Dan Ridinger
Managing Director




FutureChalk Software Inc.			
20521 92A Avenue						
Langley, BC  V1M 1B7
					
Phone No: 604.723.6837
EMail: dlr at futurechalk.com
www: www.futurechalk.com

> On Jan 27, 2022, at 8:35 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Do I leave in the parentheses that are in the Postgres documentation in this command, around the column names and around the WITH option FORMAT etc?
> 
> Do tStatObjPG.$execdirect("COPY fcCities ( cityname, city_count_num  )  FROM { '/Users/server/Desktop/JS5Dev/Cities.txt'  }  WITH  ( FORMAT csv  ) ")
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com