Ragged CSV import
От | Little, Douglas |
---|---|
Тема | Ragged CSV import |
Дата | |
Msg-id | A434C531E37AD442815608A769550D80590ABB7A8F@EGEXCMB01.oww.root.lcl обсуждение исходный текст |
Список | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Hi, </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">In sept 2009 there was a discussion of ragged csv import and import requirements. </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I thought I’d add my requirements to the heap.</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I’m working a QA solution for a dbms migration project that will import query output from a non PG databaseinto PG, so we can compare query results between PG and the alternative db. </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">The query are supposed to have the same values, but many things can get in the way. </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">My QA queries return a result set (multiple rows/columns) for each query. </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Copy improvements that would be useful</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial">1. Copy to non-existent table – create it from the data type using most generic datatypes</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">2. provide column mapping function - from what I understand that the column list on a copy from is thetarget columns to load. I assume there must be a header record and the same columns in the </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Data file. </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">The improvements discuss in the forum would be very helpful. Keep up the good work guys. </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><strong><b><font face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial">Doug Little</span></font></b></strong><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide </span></font><p class="MsoNormal"style="margin-right:-1.25in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">500W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164| Cell 847-997-5741</span></font><h3 style="margin:0in;margin-bottom:.0001pt"><strong><b><font face="Arial" size="2"><spanstyle="font-size:10.0pt;font-family:Arial;font-weight:normal"><a href="mailto:Douglas.Little@orbitz.com" title="mailto:dlittle@orbitz.com"><b><span style="font-weight:bold">Douglas.Little@orbitz.com</span></b></a></span></font></b></strong><span class="MsoHyperlink"><u><fontcolor="blue"></font></u></span></h3><p><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <imgborder="0" height="61" id="_x0000_i1025" src="cid:image002.jpg@01CA735A.7B428B90" width="83"/> <a href="http://www.orbitz.com/" title="http://www.orbitz.com/"><font face="Arial" size="1"><span style="font-size: 8.0pt;font-family:Arial"><span title="http://www.orbitz.com/">orbitz.com</span></span></font></a> <font color="blue"><spanstyle="color:blue">|</span></font> <a href="http://www.ebookers.com/" title="http://www.ebookers.com/"><fontface="Arial" size="1"><span style="font-size:8.0pt;font-family:Arial"><span title="http://www.ebookers.com/">ebookers.com</span></span></font></a><font color="blue"><span style="color:blue">|</span></font><a href="http://www.hotelclub.com/" title="http://www.hotelclub.com/"><font face="Arial"size="1"><span style="font-size:8.0pt;font-family:Arial"><span title="http://www.hotelclub.com/">hotelclub.com</span></span></font></a><font color="blue"><span style="color:blue">|</span></font><a href="http://www.cheaptickets.com/" title="http://www.cheaptickets.com/"><font face="Arial"size="1"><span style="font-size:8.0pt;font-family:Arial"><span title="http://www.cheaptickets.com/">cheaptickets.com</span></span></font></a><font color="blue"><span style="color:blue">|</span></font><a href="http://www.ratestogo.com/" title="http://www.ratestogo.com/"><font face="Arial"size="1"><span style="font-size:8.0pt;font-family:Arial"><span title="http://www.ratestogo.com/">ratestogo.com</span></span></font></a><fontcolor="blue"><span style="color:blue"> |</span></font><a href="http://www.asiahotels.com/" title="http://www.asiahotels.com/"><font face="Arial" size="1"><spanstyle="font-size:8.0pt;font-family:Arial"><span title="http://www.asiahotels.com/">asiahotels.com</span></span></font></a> </span></font><pclass="MsoNormal"><font face="TimesNew Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div>
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Robert HaasДата:
Сообщение: Re: Page-level version upgrade (was: Block-level CRC checks)
Следующее
От: Greg StarkДата:
Сообщение: Re: Page-level version upgrade (was: Block-level CRC checks)