Thread: Automated copy command?
-----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-----
On Fri, Apr 25, 2003 at 11:38:16 +0200, papapep <papapep@gmx.net> 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??? Perl would be a good way to do this. I use perl to load databases from files, but the scripts wouldn't fit you case well enough to be especially useful.
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@postgresql.org -- Aarni Ruuhimäki Megative Tmi KYMI.com Pääsintie 26 45100 Kouvola info@kymi.com / aarni.ruuhimaki@kymi.com 05 - 3755 035 / 050 - 4910 037 ------------------------------- Linux RedHat 7.3. / KDE 3.0 -------------------------------