On Tuesday 11. July 2006 10:10, A. Kretschmer wrote: >Do you have a UNIX-like operating system? Then you can use tools like >'cut': > >[EMAIL PROTECTED]:~$ echo "s1,s2,s3" | cut -d ',' -f 1,3 >s1,s3 > >This result can you pipe into psql.
It would be nice, though, if we had something like Oracle's SQL-Loader for PostgreSQL. It's a very powerful tool for transforming and loading data. -- Leif Biberg Kristensen | Registered Linux User #338009 http://solumslekt.org/ | Cruising with Gentoo/KDE ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend