On Wed, Sep 10, 2008 at 12:46 AM, Artacus <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
