Re: WIP patch - INSERT-able log statements - Mailing list pgsql-patches

From Tom Lane
Subject Re: WIP patch - INSERT-able log statements
Date
Msg-id 5371.1171587026@sss.pgh.pa.us
Whole thread Raw
In response to WIP patch - INSERT-able log statements  ("FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>)
Responses Re: WIP patch - INSERT-able log statements
List pgsql-patches
"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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: patch adding new regexp functions
Next
From: Tom Lane
Date:
Subject: Re: remove dbname arg from bootstrap mode