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
-------------------------------
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 |