I have multiple CSV files. Those CSV files are the log files created as a result of running a Windows batch file. The location of these CSV files lies on the server and I want all these CSV files to copy from the server to a particular table (say import_error_table, which I had already created in PostgreSQL).
How to accomplish this using PostgreSQL?
I tried running a Windows batch file which is shown below.
And in the above snapshot, there is an exe file to convert a shapefile to pgsql. I would like to know is there any specific exe for converting CSV to pgsql.
I had run the above code as a batch file. The prep.sql file is created with (0KB size). But also schema was not created in the PostgreSQL.
for %%f in (*.csv) do \\22.214.171.124\working\PostGIS\psql.exe -p -k -s 32643 %%f CSV_Logs.%%~nf > prep_%%~nf.sql set PGPASSWORD=rpc123 for %%f in (prep_*.sql) do \\126.96.36.199\working\PostGIS\psql -h 188.8.131.52 -p 5432 -d NPCL_test -U postgres -f %%f
The result of which is prep.sql files created but schema was not created in PostgreSQL.