Re: Postgresql and scripting

On Tuesday 07 September 2004 01:50 am, John DeSoi wrote:
> On Sep 7, 2004, at 7:24 AM, Jerome Lyles wrote:
> > test-# \i create.txt
> > psql:create.txt:1: ERROR:  syntax error at or near "" at character 1
> >
> > Here is the top of the script:
> > ------------------------------------------------------------
> >  - -   S a m s   T e a c h   Y o u r s e l f   S Q L   i n   1 0   M i
> > n u t e
>
> It seems that your file might be in unicode (utf-16) since it appears
> there is whitespace after every character. Check your editor settings
> and resave the file.
>
> Best,
>
> John DeSoi, Ph.D.
Right now it's in unicode (utf-8), switching between utf 8 and sixteen has no
effect on the spaces between letters.  Tried iso 8859-1 and iso 8859-15 but
the editor window was empty for these encodings.

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   t a b l e



 C R E A T E   T A B L E   C u s t o m e r s

 (

     c u s t _ i d             c h a r ( 1 0 )     N O T   N U L L   ,

     c u s t _ n a m e         c h a r ( 5 0 )     N O T   N U L L   ,

     c u s t _ a d d r e s s   c h a r ( 5 0 )     ,

     c u s t _ c i t y         c h a r ( 5 0 )     ,

     c u s t _ s t a t e       c h a r ( 5 )       ,

     c u s t _ z i p           c h a r ( 1 0 )     ,

     c u s t _ c o u n t r y   c h a r ( 5 0 )     ,

     c u s t _ c o n t a c t   c h a r ( 5 0 )     ,

     c u s t _ e m a i l       c h a r ( 2 5 5 )

 ) ;