Re: SQL help!!!!!!!!!!!!

On Sun, 3 Nov 1996 sfedor01_at_cs.fiu.edu wrote:

> In article <327517F2.291B_at_microtec.ca> you wrote:
> : Hi, can anyone help me with this?
 

> : I want to populate a table with the COPY command and an ascii text file
> People often use SQL*Loader to do this since its purpose is exactly to
> load data into table from flat file. Read Utilities Guide or send me
> layout and table description (if it is one table and one file).
>

Actually I use Postgres SQL (psql) and I finally did it with some help, all I had to do was this command:

COPY tablename FROM '/fullpath/filename.ext' USING DELIMITERS '_at_' ;

But thanks anyway!

                                        Regards,

                                                        Simon

Simon Tetu                                                      __
Programmation/Developpement                                   =( /=
Technologies OPTIM                                            ~//~
***  http://www.optim.com/~simtetu                            //
     e-mail:simon_at_optim.com                               .-,//
                                                          ).//\/  
 - "I hate coffee, but love JAVA!"        ___     __     /'== (
__________________________________..warp~'   \___/  ~~~-=\____/  _________