Re: Spaces in .sql File

From: Michael Ewan <michael(dot)ewan(at)intel(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Spaces in .sql File
Date: 2011-02-16 21:27:40
Message-ID: 4D5C414C.7000801@intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On 02/16/2011 01:13 PM, Rich Shepard wrote:
> The SQLite dump left a lot of spaces within a column. That is, there are
> text strings followed by a variable number of spaces before the column
> delimiter ','. Do I need to remove all these before restoring the file to a
> postgres table?
>

As long as the spaces aren't inside quotes, it shouldn't be a problem.
Assuming something that looks like...

INSERT INTO table (col1, col2, col3) VALUES (val1 , val2 ,
val2 );

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-16 21:46:15 Re: Spaces in .sql File
Previous Message Rich Shepard 2011-02-16 21:13:14 Spaces in .sql File