Re: Automated copy command?

From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: papapep <papapep(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Automated copy command?
Date: 2003-04-25 19:32:16
Message-ID: 200304251932.16783.aarni.ruuhimaki@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi !

Just to give you maybe some ideas.

I use usually a combination of scheduled parsing-templates ( to do various
things with the file like removing / replacing characters, counting rows,
renaming files etc. ) and other scheduled routines in ColdFusion + scheduled
cron jobs for the actual COPYing or maybe deleting a temp table ...

BR,

aarni

On Friday 25 April 2003 09:38, you wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Is there any way of making an automated copy of several files into tables?
>
> I've got many files named nnnnddmmyyyy.txt.mod (obviously the date is
> different in every one :-D)
>
> Has postgres any automated process or has anybody made any scrip in perl???
>
> Thanks in advance for your answers.
>
> Josep Sànchez
> ~ [papapep]
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE+qQIH2vx52x0kyz4RAu0PAKCb5axG24m0NacEKVAVxjjYaG8RHwCfeDjx
> mzUxsCaCbdviPBP0ieknOiQ=
> =YOQO
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola

info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com

05 - 3755 035 / 050 - 4910 037
-------------------------------
Linux RedHat 7.3. / KDE 3.0
-------------------------------

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-04-25 20:07:39 Re: Starting postgres with a password
Previous Message M. Bastin 2003-04-25 18:46:50 StartupPacket