On 28/08/2008 22:29, Albretch Mueller wrote: > jpk=# COPY j2sdk_1_4_2_18_binfls_md5sum FROM > '/media/hda3/prjx/JPack/REF/LANDMARKS/PROFILES/20080828104627_j2sdk-1_4_2_18-linux-i586.binfls.md5sum.txt' > CSV HEADER; > ERROR: relation "j2sdk_1_4_2_18_binfls_md5sum" does not exist > ~ > What is going on here?
Just what it says - the relation doesn't exist 'cos you haven't created it yet. You have to create the table first before you can COPY into it. > How can I fix that error, effectively creating and populating the > tables from csv files? Just include a CREATE TABLE statement in the same script before the COPY. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
