Re: Custom Insert function

Brian C. Doyle wrote:
> Hello all,
>
> Is it possible to create a function that would look like
> this_function('file.csv');
>
> and make it run
> COPY this_table FROM '/this/location/file.csv' USING DELIMITERS ',';
>
> Thus eliminating alot of repeated work each time???
>
> if so what would I put on the returns

Looks like a job for PL/TclU. It could read an external file,
do all the necessary conversions with Tcl's enhanced regular
expressions and execute inserts unsing a prepared INSERT
plan.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com