equal
deleted
inserted
replaced
594 \copy tbl_name from 'my.csv' csv; |
594 \copy tbl_name from 'my.csv' csv; |
595 \copy tbl_name from 'my.csv' delimiter ':' csv; |
595 \copy tbl_name from 'my.csv' delimiter ':' csv; |
596 |
596 |
597 $ psql -U $USER -h $HOST $DB -c "\\copy tbl_name from 'my.csv' csv" |
597 $ psql -U $USER -h $HOST $DB -c "\\copy tbl_name from 'my.csv' csv" |
598 |
598 |
|
599 Copy tables |
|
600 =========== |
|
601 |
|
602 Create table *with* data copying using another table (no constraints & indices are recreated, |
|
603 including PK):: |
|
604 |
|
605 CREATE TABLE mycopy AS TABLE myorig; |
|
606 |
|
607 Create table *without* data copying using another table:: |
|
608 |
|
609 CREATE TABLE mycopy AS TABLE myorig WITH NO DATA; |
|
610 |
|
611 Create table from select and copy data (no constraints & indices are recreated, including PK):: |
|
612 |
|
613 CREATE TABLE mycopy AS (SELECT * FROM myorig); |
|
614 |
|
615 Create table from select (without copying data):: |
|
616 |
|
617 CREATE TABLE mycopy AS (SELECT * FROM myorig) WITH NO DATA; |
|
618 |
599 JDBC driver |
619 JDBC driver |
600 =========== |
620 =========== |
601 |
621 |
602 https://jdbc.postgresql.org/about/about.html |
622 https://jdbc.postgresql.org/about/about.html |
603 The current version of the driver should be compatible with PostgreSQL 8.2 and higher, and Java 6 |
623 The current version of the driver should be compatible with PostgreSQL 8.2 and higher, and Java 6 |