Re: [Gnumed-devel] Consumable substances

[Karsten Hilbert]

> 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