Leif B. Kristensen wrote: > 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.
We do have very powerful tools, even more powerful than SQL-Loader. They require a bit more work to use though. Perl, for example. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
