On Wed, Sep 10, 2008 at 12:46 AM, Artacus <artacus@xxxxxxxxxxx> wrote: > Artacus wrote: >> >> I'd like to learn a little more about writing psql scripts does anyone >> know of any resources outside of the manual? > > Ok then. Does anyone have any tips or best practices for scripting psql? > > I'll probably write some bash scripts to pull csv files over then script > psql to do a COPY into an import schema then run a pl/pgsql procedure, er > function, to do all ETL. This sounds a lot like what I did in my last job using bash for most things, and php for the more complicated stuff. Wrote a simple oracle to pgsql table replicator in php that worked pretty well.
