Syntax for Postgres command

Doug Easterbrook doug at artsman.com
Thu Jan 27 17:10:09 UTC 2022


I always test major changes to SQL in pgadmin or psql first

if that works, then I’ll put in in an application.


it could be a permissions thing.  who knows if the database engine has access to '/Users/server/Desktop/JS5Dev/Cities.txt'


Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On January 27, 2022, at 9:07 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Do tStatObjPG.$execdirect("COPY fcCities ( cityname, city_count_num, city_cntry_num, long_deg, long_min, lat_deg, lat_min, long_we, lat_ns, city_rsn, city_state, ctime_zone, long_sec, lat_sec, city_acs_zone, city_acs_type, city_new, zone_we, city_ascii, city_alternate, city_latnum, city_Longnum, city_state_name, city_timezone_name, city_country_name, city_state_code, city_country_digits, city_acs, city_population )  FROM  '/Users/server/Desktop/JS5Dev/Cities.txt'  WITH  FORMAT 'csv', DELIMITER ',' “)
> 
> I tried the above command and it did nothing. It stepped right through it.
> 
> The file has 1.7 million city records in it. So it should take at least some time to execute. 
> 
> I am attempting to import the records into a Postgres database. 
> 
> I test and the statement object is good.
> 
> I am connected to localhost Postgres. I get a session object under the SQL Browser so I know I am connected.
> 
> I have made the table in question.
> 
> What could possibly be the reason for it just stepping through it without doing anything?
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list