"FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au> writes:
> The second variable is of interest. We need to specify a table in the insert command. My preferred option is for the
userto give one and he can create it if and when he wants to. The alternative is we decide the table name and make
initdbto create one.
Why not output the data in COPY format instead? That (a) eliminates the
problem of needing to predetermine a destination table name, and (b)
should be considerably faster to load than thousands of INSERT statements.
regards, tom lane