Thread: Massive Insertion
Hello,<br /><br /> I would like to know if there's a function that allows to insert values in table using a csv file?<br/><br /> Best regards
2009/12/10 Florent THOMAS <mailinglist@tdeo.fr>
Hello,
I would like to know if there's a function that allows to insert values in table using a csv file?
Best regards
You can use the COPY command for that: http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
Regards
Thom
Le jeudi 10 décembre 2009 à 10:54:37, Florent THOMAS a écrit : > Hello, > > I would like to know if there's a function that allows to insert values > in table using a csv file? > Not in pgAdmin. But you can use the COPY statement or pgloader. -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com
Thanks a lot for all your fast answers.<br /><br /> It's exactly what I was looking for.<br /><br /> best regards<br /><tablecellpadding="0" cellspacing="0" width="100%"><tr><td><br /></td></tr></table><br /> Le jeudi 10 décembre 2009 à 11:06+0100, Patrick Rodies a écrit :<br /><blockquote type="CITE"><a href="http://www.postgresql.org/docs/8.1/static/sql-copy.html">http://www.postgresql.org/docs/8.1/static/sql-copy.html</a><br /><br/></blockquote><blockquote type="CITE"> 2009/12/10 Florent THOMAS <<a href="mailto:mailinglist@tdeo.fr">mailinglist@tdeo.fr</a>></blockquote><blockquote type="CITE"><blockquote> Hello,<br/><br /> I would like to know if there's a function that allows to insert values in table using a csv file?<br /><br/> Best regards </blockquote></blockquote><blockquote type="CITE"><br /><br /><br /> -- <br /> Mange hilsener / Bestregards<br /><br /> <br /> --------------------------------------------------------------------------------------------<br/> <br /> Patrick Rodies| Technical manager<br /> email: <a href="mailto:pr@previewnetworks.com">pr@previewnetworks.com</a> | mobile: +45 3126 49 76 | phone: +45 70 27 87 77<br /> Preview Networks Ltd. | Njalsgade 21F, 1st floor | DK-2300 Copenhagen S<br /><br/> For info: <a href="http://www.previewnetworks.com">www.previewnetworks.com</a> | For fun! <a href="http://www.filmtrailer.com">www.filmtrailer.com</a><br/><br /> Linking high-quality entertainment content to a widevariety of selected online <br /> media in a simple and time-efficient manner. Enabling content owners and web <br />editors to focus on their core competencies and developing their business.<br /> <br /> --------------------------------------------------------------------------------------------</blockquote>
Dear everyone,<br /><br /> Thank you for the information about "copy into".<br /> I would like to if it is possible to catchthe result of this command in a record or in a cursor?<br /><br /> Best regards<br /><table cellpadding="0" cellspacing="0"width="100%"><tr><td><br /></td></tr></table><br /> Le jeudi 10 décembre 2009 à 11:19 +0100, Patrick Rodiesa écrit :<br /><blockquote type="CITE"> Pas de problem Florent.<br /><br /> Patrick<br /><br /></blockquote><blockquotetype="CITE"> 2009/12/10 Florent THOMAS <<a href="mailto:mailinglist@tdeo.fr">mailinglist@tdeo.fr</a>></blockquote><blockquote type="CITE"><blockquote> Thanks a lotfor all your fast answers.<br /><br /> It's exactly what I was looking for.<br /><br /> best regards<br /><table cellpadding="0"cellspacing="0" width="100%"><tr><td><br /><br /></td></tr></table><br /> Le jeudi 10 décembre 2009 à 11:06+0100, Patrick Rodies a écrit :<br /><blockquote type="CITE"><a href="http://www.postgresql.org/docs/8.1/static/sql-copy.html">http://www.postgresql.org/docs/8.1/static/sql-copy.html</a><br /><br/> 2009/12/10 Florent THOMAS <<a href="mailto:mailinglist@tdeo.fr">mailinglist@tdeo.fr</a>><br /><blockquote>Hello,<br /><br /> I would like to know if there's a function that allows to insert values in table using acsv file?<br /><br /> Best regards <br /></blockquote><br /><br /><br /> -- <br /> Mange hilsener / Best regards<br /><br/> <br /> --------------------------------------------------------------------------------------------<br /> <br />Patrick Rodies | Technical manager<br /> email: <a href="mailto:pr@previewnetworks.com">pr@previewnetworks.com</a> | mobile:+45 31 26 49 76 | phone: +45 70 27 87 77<br /> Preview Networks Ltd. | Njalsgade 21F, 1st floor | DK-2300 CopenhagenS<br /><br /> For info: <a href="http://www.previewnetworks.com">www.previewnetworks.com</a> | For fun! <a href="http://www.filmtrailer.com">www.filmtrailer.com</a><br/><br /> Linking high-quality entertainment content to a widevariety of selected online <br /> media in a simple and time-efficient manner. Enabling content owners and web <br />editors to focus on their core competencies and developing their business.<br /> <br /> -------------------------------------------------------------------------------------------- </blockquote></blockquote></blockquote><blockquotetype="CITE"><br /><br /><br /> -- <br /> Mange hilsener / Best regards<br/><br /> <br /> --------------------------------------------------------------------------------------------<br/> <br /> Patrick Rodies| Technical manager<br /> email: <a href="mailto:pr@previewnetworks.com">pr@previewnetworks.com</a> | mobile: +45 3126 49 76 | phone: +45 70 27 87 77<br /> Preview Networks Ltd. | Njalsgade 21F, 1st floor | DK-2300 Copenhagen S<br /><br/> For info: <a href="http://www.previewnetworks.com">www.previewnetworks.com</a> | For fun! <a href="http://www.filmtrailer.com">www.filmtrailer.com</a><br/><br /> Linking high-quality entertainment content to a widevariety of selected online <br /> media in a simple and time-efficient manner. Enabling content owners and web <br />editors to focus on their core competencies and developing their business.<br /> <br /> --------------------------------------------------------------------------------------------</blockquote>