Syntax for Postgres command

Dan Ridinger dlr at
Fri Jan 28 18:55:34 UTC 2022

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

> On Jan 27, 2022, at 8:35 AM, Das Goravani <goravanis at> 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
> Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list