| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Artacus <artacus(at)comcast(dot)net> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: psql scripting tutorials |
| Date: | 2008-09-10 19:47:42 |
| Message-ID: | dcc563d10809101247i68fdd130tef2536c86a5d362f@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 10, 2008 at 12:46 AM, Artacus <artacus(at)comcast(dot)net> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben | 2008-09-10 20:03:08 | abusing plpgsql array variables |
| Previous Message | Steve Holdoway | 2008-09-10 19:31:07 | Re: [GENERAL] FW: How to upload data to postgres |