> I' like to know if you can suggest me how I can import data in a postgresql > table from a .txt file (with fields separated by semicolon ) Using psql, you can issue a COPY tablename FROM '/dir/textfile' USING DELIMITERS ';'; Which should work fine. tablename should exist already and the fields should have appropriate types. The \copy command would probably stumble on the fact your delimiters are ';' characters. You mush have superuser priviledges to issue the sql COPY command. cr
- [ADMIN] X-Mailer: USANET web-mailer (M3.0.0.118) Benzi Emanuele
- christian
