# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1545131181 -7200
# Node ID 2d52dea2eee3ed631c0ddbf622f21c61ea11633b
# Parent  a2b7bf3976b56d136f3f4e80c8bc6cf5d9beef9e
Import data.

diff -r a2b7bf3976b5 -r 2d52dea2eee3 postgres.rst
--- a/postgres.rst	Tue Dec 18 13:06:09 2018 +0200
+++ b/postgres.rst	Tue Dec 18 13:06:21 2018 +0200
@@ -14,8 +14,8 @@
   $ sudo apt-get install postgresql postgresql-client
   $ sudo su - postgres
   % psql
-  postgres=# CREATE USER "mypguser" WITH PASSWORD 'mypguserpass';
-  postgres=# CREATE DATABASE "mypgdatabase" OWNER "mypguser";
+  postgres=# CREATE USER myuser WITH PASSWORD 'mypass';
+  postgres=# CREATE DATABASE mydb OWNER myuser;
   postgres=# \q
 
 Connect as user ``mypguser`` to new database::
@@ -192,3 +192,13 @@
 
   \copy (SELECT * FROM foo) TO '/tmp/my.csv' WITH CSV
 
+Import data
+===========
+
+Import CSV file::
+
+  \copy tbl_name from 'my.csv' csv;
+  \copy tbl_name from 'my.csv' delimiter ':' csv;
+
+  $ psql -U $USER -h $HOST $DB -c "\\copy tbl_name from 'my.csv' csv"
+