equal
deleted
inserted
replaced
53 :: |
53 :: |
54 |
54 |
55 SHOW hba_file; |
55 SHOW hba_file; |
56 SHOW config_file; |
56 SHOW config_file; |
57 |
57 |
|
58 Check settings |
|
59 ============== |
|
60 :: |
|
61 |
|
62 SELECT name, setting FROM pg_settings; |
|
63 |
58 List databases, schemas and tables |
64 List databases, schemas and tables |
59 ================================== |
65 ================================== |
60 |
66 |
61 Default database is ``postgres``. |
67 Default database is ``postgres``. |
62 |
68 |
213 \copy tbl_name from 'my.csv' csv; |
219 \copy tbl_name from 'my.csv' csv; |
214 \copy tbl_name from 'my.csv' delimiter ':' csv; |
220 \copy tbl_name from 'my.csv' delimiter ':' csv; |
215 |
221 |
216 $ psql -U $USER -h $HOST $DB -c "\\copy tbl_name from 'my.csv' csv" |
222 $ psql -U $USER -h $HOST $DB -c "\\copy tbl_name from 'my.csv' csv" |
217 |
223 |
|
224 JDBC driver |
|
225 =========== |
|
226 |
|
227 https://jdbc.postgresql.org/about/about.html |
|
228 The current version of the driver should be compatible with PostgreSQL 8.2 and higher, and Java 6 |
|
229 (JDBC 4.0), Java 7 (JDBC 4.1), Java 8 (JDBC 4.2) and Java 9. |
|
230 https://jdbc.postgresql.org/download.html |
|
231 Java/JDBC/Postgres compatibility table. |
|
232 |