| From: | Andreas <maps(dot)on(at)gmx(dot)net> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Subject: | Re: Howto import regularly some CSV files with variing names? |
| Date: | 2013-09-24 00:47:13 |
| Message-ID: | 5240E111.7090308@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 24.09.2013 02:25, schrieb Adrian Klaver:
> On 09/23/2013 05:19 PM, Andreas wrote:
>>
>> I need to import some log-files of an application [...]
>> The import would be easy if the files had a constant name but the app
>> creates csv files with names like "ExportYYYYMMDD".
>>
>>
>> So how would I get the filenames into the sql-script?
>
> Do man on find and look for -exec.
>
I could find the files and exec a shell script but how can I have a SQL
script take the found filenames as parameter?
The SQL script needs to create a temp table
then COPY the file with the filename it got as parameter into the temp table
then insert from there into the log-table
How would I get the filenames into the SQL script?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-09-24 00:49:55 | Re: How to create recurrence schedule event? |
| Previous Message | Muhammad Bashir Al-Noimi | 2013-09-24 00:29:29 | Re: Building with MinGW issue |