Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | Future |
http://jdbc.postgresql.org/documentation/publicapi/index.html?org/postgresql/copy/CopyManager.html
Copied from Issue #11151:
COPY command options via JDBC:
-- http://stackoverflow.com/questions/6958965/how-to-copy-a-data-from-file-to-postgresql-using-jdbc
-- http://www.postgresql.org/docs/8.1/static/sql-copy.html
-- this is different from our import b/c the file is directly passed to the server. COPY syntax doesn't seem to allow for arbitrary user mapping of columns. Requires further investigation. COPY does seem to support STDIN so maybe it is possible to dynamically generate COPY statements as opposed to INSERT statements.
This approach might work for postgresql, greenplum, paraccel & redshift
Issue #10226 |
| In Progress |
Completion |
| No due date |
| No fixed build |
| No time estimate |
2 issue links |
relates to #10227
Issue #10227Native support for Redshift |
is a duplicate of #11151
Issue #11151Support COPY command for postgresql related DBs |
Copied from Issue #11151:
COPY command options via JDBC:
-- http://stackoverflow.com/questions/6958965/how-to-copy-a-data-from-file-to-postgresql-using-jdbc
-- http://www.postgresql.org/docs/8.1/static/sql-copy.html
-- this is different from our import b/c the file is directly passed to the server. COPY syntax doesn't seem to allow for arbitrary user mapping of columns. Requires further investigation. COPY does seem to support STDIN so maybe it is possible to dynamically generate COPY statements as opposed to INSERT statements.
This approach might work for postgresql, greenplum, paraccel & redshift