Re: [GENERAL] Postgresql and scripting

2004-09-08 Thread Tom Lane
Jerome Lyles <[EMAIL PROTECTED]> writes: > psql:create.txt4:34: ERROR: type "datetime" does not exist > Does this mean this datatype doesn't exist on this line (34) or that it > doesn't exist at all? If it doesn't exist at all what is the correct > datatype to use here? It doesn't exist at al

Re: [GENERAL] Postgresql and scripting

2004-09-08 Thread Greg Stark
Jerome Lyles <[EMAIL PROTECTED]> writes: > the/@@/ is what the whitespace is replaced with but I don't know what the @@ > stands for, It doesn't stand for anything, it just means replace with "@@". Now look again at the second and third substitution... -- greg ---(end

Re: [GENERAL] Postgresql and scripting

2004-09-08 Thread Jerome Lyles
On Tuesday 07 September 2004 10:22 pm, Dorward villaruz wrote: > hi! > > try this in commandline i assume you save the file in sams.txt > final file will be sams2.txt > > cat sams.txt | sed -e 's/ /@@/g' -e 's/ //g' -e 's/@@/ /g' > sams2.txt > > or put this in a script say convert.sh > > script st

[GENERAL] Postgresql and scripting

2004-09-08 Thread Jerome Lyles
I took the white space between characters out of my script 'create.txt4' and ran it on database 'test'. There were errors: 26 27 -- Create Orders Table 28 29 CREATE TABLE Orders 30 ( 31Order_num int NOT NULL, 32Order_datedatetimeNOT NULL, 33cust_id char

Re: [GENERAL] Postgresql and scripting

2004-09-08 Thread Oliver Elphick
On Wed, 2004-09-08 at 00:33, Jerome Lyles wrote: ... > Can someone point me to a sed or shell script that I can use on a text file to > remove the whitespace between the letters in the words only? Here is the > top of the script file as it stands now: > > - - C r e a t e C u s t o m e r s