Re: Importing 120 csv files bulk multiple

Awesome, thanks!

On Tue, Feb 12, 2013 at 3:35 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 02/12/2013 07:14 AM, Andrew Taylor wrote:
>
>> Hi,
>>
>> As per title I need to import a load of csv files. So I wrote a bash
>> script to generate the statements I needed (attached). However, this is
>> failing on my ubuntu laptop - it seems to occasionally miss the
>> semicolon to execute. What I did was copy the text to clipboard and
>> paste it in to bash. Is there maybe a way to open this file and evaluate
>> it within psql? Output shown below:
>>
>>
>>
> If you want to look at by opening an editor:
>
> test=> \e poscodeInput.txt
>
> If you want to run it:
>
> test=> \i poscodeInput.txt
>
> Substitute path as needed.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>