FAST PostgreSQL wrote: > On Fri, 16 Feb 2007 11:50, Tom Lane wrote: >> "FAST PostgreSQL" <[EMAIL PROTECTED]> writes: >>> The second variable is of interest. We need to specify a table in the >>> insert command. My preferred option is for the user to give one and he >>> can create it if and when he wants to. The alternative is we decide the >>> table name and make initdb to 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. > > Yeah, that was my initial idea too... But because the TODO item clearly > mentions INSERT, I thought maybe there was some very specific reason for the > output to be in INSERT stmts.. ..
COPY would be a good option, but INSERT is probably what I would use as the default. The most use I see for this is something where I am tailing out the log and inserting live into a log db... Sincerely, Joshua D. Drake > > Rgds, > Arul Shaji > > > >> regards, tom lane > This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 > 003 693 481. It is confidential to the ordinary user of the email address to > which it was addressed and may contain copyright and/or legally privileged > information. No one else may read, print, store, copy or forward all or any > of it or its attachments. If you receive this email in error, please return > to sender. Thank you. > > If you do not wish to receive commercial email messages from Fujitsu > Australia Software Technology Pty Ltd, please email [EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
