No. I installed the driver on 64-bit Windows.
I can not find the dll file in version 3.8.13, 3.8.12, but can find the file in version 3.8.11
Search found 5 matches
- Wed 13 Sep 2017 09:30
- Forum: dbExpress driver for PostgreSQL
- Topic: PostgreSQL 3.9.13 64bit dll
- Replies: 4
- Views: 41729
- Wed 13 Sep 2017 03:08
- Forum: dbExpress driver for PostgreSQL
- Topic: PostgreSQL 3.9.13 64bit dll
- Replies: 4
- Views: 41729
PostgreSQL 3.9.13 64bit dll
Hi,
I installed dbpgsql39.exe, but i cannot find "PostgreSql\bin\Win64" folder.
Where can i get 64bit dll file?
I installed dbpgsql39.exe, but i cannot find "PostgreSql\bin\Win64" folder.
Where can i get 64bit dll file?
- Fri 27 Apr 2012 10:04
- Forum: dbExpress driver for PostgreSQL
- Topic: Failed to invoke copy to remote psql server
- Replies: 5
- Views: 3778
Hi.
I think that you are being confused 'copy' and '\copy' or you don't know '\copy' command.
I know how to use 'copy' with a file existing on a psql server.
But my concern is that it has failed to invoke 'copy' with a query data file existing on client side through dbx driver connected with network.
The file is not existing on a psql server but client side.
In addition, it was successful to invoke '\copy' with a query data file existing on client side by psql shell on client side, but failed through dbx driver with error message 'syntax error at or near "\"'.
I think that you are being confused 'copy' and '\copy' or you don't know '\copy' command.
I know how to use 'copy' with a file existing on a psql server.
But my concern is that it has failed to invoke 'copy' with a query data file existing on client side through dbx driver connected with network.
The file is not existing on a psql server but client side.
In addition, it was successful to invoke '\copy' with a query data file existing on client side by psql shell on client side, but failed through dbx driver with error message 'syntax error at or near "\"'.
- Wed 25 Apr 2012 03:51
- Forum: dbExpress driver for PostgreSQL
- Topic: Failed to invoke copy to remote psql server
- Replies: 5
- Views: 3778
Hello,
As you know, I have already been using copy command to a local psql server without '\ symbol through psql shell or dbx driver.
But now I have failed to invoke copy command to a remote psql server.
Following is that I refered to states of PSQL documentation 'sql-copy.html'.
"Do not confuse COPY with the psql instruction \copy. \copy invokes COPY FROM STDIN or COPY TO STDOUT, and then fetches/stores the data in a file accessible to the psql client. Thus, file accessibility and access rights depend on the client rather than the server when \copy is used."
from http://www.postgresql.org/docs/9.1/static/sql-copy.html
Repeatly, It was successful to invoke copy command with '\ to remote psql server through psql shell, but failed to remote psql server through dbx driver.
Please let me know how to invoke copy command to remote psql server through dbx driver.
As you know, I have already been using copy command to a local psql server without '\ symbol through psql shell or dbx driver.
But now I have failed to invoke copy command to a remote psql server.
Following is that I refered to states of PSQL documentation 'sql-copy.html'.
"Do not confuse COPY with the psql instruction \copy. \copy invokes COPY FROM STDIN or COPY TO STDOUT, and then fetches/stores the data in a file accessible to the psql client. Thus, file accessibility and access rights depend on the client rather than the server when \copy is used."
from http://www.postgresql.org/docs/9.1/static/sql-copy.html
Repeatly, It was successful to invoke copy command with '\ to remote psql server through psql shell, but failed to remote psql server through dbx driver.
Please let me know how to invoke copy command to remote psql server through dbx driver.
- Tue 24 Apr 2012 06:50
- Forum: dbExpress driver for PostgreSQL
- Topic: Failed to invoke copy to remote psql server
- Replies: 5
- Views: 3778
Failed to invoke copy to remote psql server
Hi..
I have failed to invoke copy query to remote psql server through dbx driver with message 'sntax error at or near "\"'
ex) SQLConnection1.ExecuteDirect('/copy test from ''d:\a.txt''');
It was successful to invoke same query through SQL shell provided psql.
Please let me know how to invoke remote copy query through dbx driver.
Thanks and regards.
I have failed to invoke copy query to remote psql server through dbx driver with message 'sntax error at or near "\"'
ex) SQLConnection1.ExecuteDirect('/copy test from ''d:\a.txt''');
It was successful to invoke same query through SQL shell provided psql.
Please let me know how to invoke remote copy query through dbx driver.
Thanks and regards.