|
From: | Karsten Hilbert |
Subject: | Re: [Gnumed-devel] Consumable substances |
Date: | Mon, 5 Sep 2011 19:35:48 +0200 |
User-agent: | Mutt/1.5.21 (2010-09-15) |
> using which COPY method I guess there isn't much of a choice: - gmPsql.py does not support \COPY - SQL copy requires - the data file to reside on the server machine - the data file to be readable by the server demon user - connection as superuser (postgres) Using direct SQL is very much the easiest route. It can easily be generated from COPY FROM data files: - locally load the data via COPY FROM (it doesn't matter which database) - dump it back out using pg_dump: pg_dump -U gm-dbo -d the_database --data-only --table=the_table -f install-data-pack.sql Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
[Prev in Thread] | Current Thread | [Next in Thread] |