Re: Importing 120 csv files bulk multiple

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.klaver@gmail.com