From premiladevi.dayalan@agbnielsen.com Tue Aug  11 03:54:57 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 48A67632CE1
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 00:54:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 95762-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 03:54:45 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.agbnielsen.com.my (mail.agbnielsen.com.my [210.19.207.77])
	by mail.postgresql.org (Postfix) with ESMTP id CA4A06327AF
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 00:54:45 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.agbnielsen.com.my (Postfix) with ESMTP id E533439A532
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 11:54:39 +0800 (MYT)
X-Virus-Scanned: amavisd-new at agbnielsen.com.my
Received: from mail.agbnielsen.com.my ([127.0.0.1])
	by localhost (mail.agbnielsen.com.my [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id QROtByb9IpiV for <pgsql-sql@postgresql.org>;
	Tue, 11 Aug 2009 11:54:35 +0800 (MYT)
Received: from MSAPMILA (unknown [211.25.202.206])
	by mail.agbnielsen.com.my (Postfix) with ESMTP id 7F1F439A51E
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 11:54:35 +0800 (MYT)
From: "Premila Devi" <premiladevi.dayalan@agbnielsen.com>
To: <pgsql-sql@postgresql.org>
Subject: Import (.CVS File) to postgreSql
Date: Tue, 11 Aug 2009 11:54:32 +0800
Message-ID: <000901ca1a37$6fa29590$4ee7c0b0$@dayalan@agbnielsen.com>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_NextPart_000_000A_01CA1A7A.7DC5D590"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcoaN29ef8VKhpd0RdKyZ4p7indLtA==
Content-Language: en-my
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.726 tagged_above=-10 required=5 tests=AWL=-0.725,
	BAYES_50=0.001, HTML_MESSAGE=0.001, MSGID_MULTIPLE_AT=1.449
X-Spam-Level: 
X-Archive-Number: 200908/36
X-Sequence-Number: 32945

This is a multipart message in MIME format.

------=_NextPart_000_000A_01CA1A7A.7DC5D590
Content-Type: multipart/related;
	boundary="----=_NextPart_001_000B_01CA1A7A.7DC5D590"


------=_NextPart_001_000B_01CA1A7A.7DC5D590
Content-Type: multipart/alternative;
	boundary="----=_NextPart_002_000C_01CA1A7A.7DC5FCA0"


------=_NextPart_002_000C_01CA1A7A.7DC5FCA0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Dear All,

 

I like to import (.CVS File) to postgreSql.Could anyone help me. May I know,
what the requirement.

 

Herewith I attach an Example of CVS File,Plese tell me how to restore in
Postgresql.

 

Thank you.

 

 <http://www.agbnielsen.com/>
http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg

Warmest Regards,

Premila Devi Dayalan Ramasamy 
Programmer Analyst 
MSAP Production Development 

AGB Nielsen Media Research
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling Jaya ,
Selangor 
( Malaysia ) 

t: 603-7620 2320 
f: 603-7620 2316 

Please note:
This email transmission including its attachments, are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any views or opinions are solely those of the
author and do not necessarily represent those of AGB Nielsen Media Research,
unless specifically stated. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If you
received this email in error, please contact the sender and delete the email
transmission immediately.


------=_NextPart_002_000C_01CA1A7A.7DC5FCA0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:DFKai-SB;
	panose-1:3 0 5 9 0 0 0 0 0 0;}
@font-face
	{font-family:"\@DFKai-SB";
	panose-1:3 0 5 9 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-priority:99;
	mso-style-link:"Balloon Text Char";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-priority:99;
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-MY link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span style=3D'font-size:8.0pt'>Dear =
All,<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:8.0pt'>I like to import =
(.CVS File)
to postgreSql.Could anyone help me. May I know, what the =
requirement.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:8.0pt'>Herewith I attach =
an Example
of CVS File,Plese tell me how to restore in =
Postgresql.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:8.0pt'>Thank =
you.<o:p></o:p></span></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal><a href=3D"http://www.agbnielsen.com/"><span =
style=3D'font-size:
12.0pt;font-family:"Times New =
Roman","serif";color:blue;text-decoration:none'><img
border=3D0 width=3D120 height=3D77 id=3D"_x0000_i1025"
src=3D"cid:image001.jpg@01CA1A7A.02E56200"
alt=3D"http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg"></span></a><=
span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman","serif"'><o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'>Warmest =
Regards,</span><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman","serif"'><o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'>Premila Devi Dayalan =
Ramasamy <br>
</span><span style=3D'font-size:10.0pt;font-family:DFKai-SB'>Programmer =
Analyst </span><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'><br>
</span><span style=3D'font-size:10.0pt;font-family:DFKai-SB'>MSAP =
Production
Development </span><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'>AGB Nielsen Media =
Research<br>
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling =
Jaya ,
Selangor <br>
( Malaysia ) </span><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><o:p></o:p></span></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'>t:</span><span =
style=3D'font-size:
10.0pt;font-family:DFKai-SB'> 603-7620 2320 <br>
</span><span =
style=3D'font-size:10.0pt;font-family:DFKai-SB'>f:</span><span
style=3D'font-size:10.0pt;font-family:DFKai-SB'> 603-7620 2316 =
</span><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman","serif"'><o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:7.5pt;font-family:DFKai-SB'>Please
note:</span><span style=3D'font-size:7.5pt;font-family:DFKai-SB'><br>
</span><span style=3D'font-size:7.5pt;font-family:DFKai-SB'>This email
transmission including its attachments, are intended only for the person =
or
entity to which it is addressed and may contain confidential and/or =
privileged
material. Any views or opinions are solely those of the author and do =
not
necessarily represent those of AGB Nielsen Media Research, unless =
specifically
stated. Any review, retransmission, dissemination or other use of, or =
taking of
any action in reliance upon, this information by persons or entities =
other than
the intended recipient is prohibited. If you received this email in =
error,
please contact the sender and delete the email transmission =
immediately.</span><o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_002_000C_01CA1A7A.7DC5FCA0--

------=_NextPart_001_000B_01CA1A7A.7DC5D590
Content-Type: image/jpeg;
	name="image001.jpg"
Content-Transfer-Encoding: base64
Content-ID: <image001.jpg@01CA1A7A.02E56200>

/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAZAAA/+4ADkFkb2JlAGTAAAAAAf/b
AIQAAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQICAgICAgICAgIC
AwMDAwMDAwMDAwEBAQEBAQECAQECAgIBAgIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMD
AwMDAwMDAwMDAwMDAwMDAwMD/8AAEQgATQB4AwERAAIRAQMRAf/EAIMAAQACAwEBAQAAAAAAAAAA
AAAHCAUGCQQDCgEBAAICAgMAAAAAAAAAAAAAAAUHBggCBAEDCRAAAQQDAQABBAMBAQEAAAAABQME
BgcBAggACRESExQVFhciIyQRAAICAQMDBAICAwAAAAAAAAECAAMRBAUGIRIHMUEiE1EIMhRxgcH/
2gAMAwEAAhEDEQA/AP38eRHkR5EeRHkR5EeRHkR5EeRHkR5EeRHkR5EeRHkR5EeRKJd79PSvmuuY
04gjJipMJ2edBRhYs0/fGAWg1j/IEX2zHKqWjwgprumm3TU+qX/W+++Nsafbtrf+y3mDevEvFdJZ
xuus79uWpaqu2xe+ula077H7MgM5yqorfHqzEHtwcI51yXVcc2+ttCq/273KqzDIUAZJx7n0AB6e
pPpK+cA9sWreFhHautjcWec5jbyUAJKLDtQrtt/FvB7R8LKtR/4h67ZdMhqogtokmppvptpv9+N9
c61f+sv7B808h8o1PDuamnU2/wBR9RTqK6lqZfrZFeuxUwhVg4ZGCgggq3d3AiA4JzLdN63B9s3T
tsb6y6uqhSO0gFWA6EHOQcA+xznpXr51vk2urgOFUvD+e2gIdZN1vpg8Xn0nBJyNhEIxBtY9q7RC
BnucByMjNP5IjpjZ3qsi1bJKbZR33UT20+q3hDxts/PNbrNXv5dtt0S1j6kbsNj2d+O5h8gihD/H
BYkdQAc5fyXeNRtdddelwLrM/IjOAMeg9MnPv7e00T4J/lavLu0hcNMdINwp6xKyj4WfALHjEcax
hoeihcsoBfBpOJGbaBmp4WTyhu0VaIoaO2qin3J43Qzup3vN/i3ZODppN446XTb9TY1TUu5cq6r3
BkY/Ioy57gxJVgOuGwPVxre9TuZs0+rwbUAYMBjIJxgj0yD6Y9R/ifow9r3MsjyI8iPIjyI8iPIj
yI8iPIjyJB3RFOwG7KvPxewBGxJgwaupAJdNnCjImGNDGLrdoRGPkv8AtuvjTfdPfGcbJqpb7ab6
7Yz9PV15T4HxryFw7U7Pyeg26apGuqZWKWVW1oxWytx1U4ypHVWUlWBBkLyDaNDvW2WaXXp3IoLK
QcMrKDgqfY+34IJBnH3nilLLrqiat7C5z/dP2CkhLm9qVqQU/dYT2FtJYRYbso82SQ0ctSDJqGSV
yinvsqqrrhVL/vT8K2ivi3x9y7ivjjZvO3ir7NTydV1S7joHPems0i6l0KUKAGV0WpW7VJZmAdPk
vZZUuwbNuO3bJpuW8f7rNeBYLqT1FtYcjCjGQQFBwDknqOowbf3Nz3x18wXPsXbWSMMvWkbMqkw5
GPGNY3aFSTFVsk1PCk32Wz5Fv++2S1ScoOWzli/R0SVxpnbRLdP6ReBP2BXc9qXmvj7UKFuT6tVp
rl7jXYvU06ivIIdGyUdSMg9yHtYiWZpdRs/MtsTUJkgHqM4et/dT+P8AYwwwZJ3Dfx3c0/HvD5NF
aAAnv3puRZkprOJsZ0kc3lCgxNwkHZECiLIYxbCA2jtb9Vo0at0E911N867Kb7b5sPm3kDkfPtZX
qt+sr7KVIrrrXsrTOO4hcklmwO5mYk4AzgASW23atHtVbJpQcsepJyT+OvToPYAS83sJklHkR5Ee
RHkR5EeRHkR5EeRHkTn58iHRUvoOqgLSCotkZFZBkhGsHnrRN+3BCWotR2VUbtF8bNVSr5NXRJvl
XG6emv5N/s2zrr9NYv2l8qb7404ZpqOOKi7pu2oej7nUOtNa1lrCqn4mxwQqdwIA72wSBMD5/wAg
1exbXWmiAGo1LlO4jIVQuWwD07j6DPQdTiVI+LLoWYPTTrnIym1IRARFzUph7tJqmgQArInG65ca
7cI664fjiTk9usnurjKqK2v2Y2203110pD9NfKO+37g/irXBLdio0duo0rBQHpIuU21sw/mljXFg
W+SMO0EqwC4p4x3/AFb3Hj1wDaRKmes46phh3KT7glsjPUHpnB6fPuvJLkK1wlpc8nitdSG8Rcnb
z4WPHjHcTIOgrgUvqdbDiTR2xQkDlcxtvvnCWfx7fcrp9uyyv5OH7Hf2/BvNdPzHxdqbtq3TkVOo
GtrRK20ztU1Z+5UsVkFzNaScL8Tl17TY/d45v9nE90Tc9gsbT361XFqgKUJUr8gCCAxLfjp1Ixk5
nL45esrLvVedQC03WsjMxMaOkYiXpDWg5dwMfvVR7kSa0GoNRyjtBzjRRqpoknuollTG/wB2U8be
sX9VPNnLvI9m5cZ5k41ev0VNd9WqFaozVu5RqrRWFQsGw1bBVLL3hs9uZNePeU7lvbX6Dcz9ltSh
1swASCcFWxgZBwVOBkZz6TqZ7cqWdHkR5EeRHkR5EeRHkR5EeRHkSLbhpqAXtCXkBscRsVBOnDd6
go3cbsigok0zt+sUEEUf/Zg/R1U30+/X642T3202xtpttrnDed8C4z5I4/ZxrldBu253V1KsUsrs
XPbZU46o4BIyPVSykFSQYzd9n0G+aI6HcE7qCQRg4ZSPRlPsf+Eg9DI/oDlGnebMHVq4FE8lpHqg
iVkEiJ5Mm1WDbb8iAtB1lBsk0G6L/wDplJJPTCin023ztnXX6Yx4y8K8E8TDU2cUpuOt1YAsuvs+
20ovUVhsKFrB+RVVHc3VskDHQ2Hi20cd7ztyt9tmO5nPc2B6KDgYGeuAOp9fabRefP8AWfREVbxK
yxC71owfakw5QY72GnQj7Gn4lVxRNPRTZDDpvnKaye2u6S2n0+/TOddc6zPkbxjxHynsq7Jy2hrK
KrPsqsrb67qn9Ca7ADjuX4upBVh/JSQCOzvew7byDSjS7ihZVbKsDhlP5U+2R0I6gj1HpPHQ3OVW
84x4lHq0FPG2pp9oQNmDD7YqeLro6bJNNHxHZNH6tWCSm2qCKeiaSf375xr92+2c9fxr4p4b4o2u
3a+JU2KNRYHuttf7LrSBhQ74HxQEhFACrliBliTx2Pj22ce07afblI72yzMe5mPtk/gewGAMn8mT
t6yJNx5EeRHkR5EeRHkR5E5ffIv8gco4kKUa2h9ToWqLPlzFk9Hk1DCo/ek+RK5OQeNW7cjdo302
yVOAjFmhsD2S26KLtPR39Ns7I/b5E2K8Onui5D0y+5H4yjFFkJ1AKWi18XZanQJuZ719BY7Y8mls
VqmEAYlWyWkklM1nLmAG3y6zggLYCRTNNf6vVXCbbCJW65vkE6+rVnxdApRUXNfN15dGz/o2BWE8
6Ltgo+oyM6c/RcpIh8zgE2h2wsqci1xsx6T0AmVbjCaDV7ok7apuE98ZRLS/H117YnVoe/2FkRKt
0DFA3Y4qBvbdDyo1OeeLyb6QqJTJeVVLKD4oY/cYi72UqR88z+9+mPODHCOHamcbaJIkQ018kckm
XYXV/MNk1qAhQSuZbYcW5gsIecIPEbrN0nXNfz26INJWTtsmlH57FBVmCCzNu2UV0JgVXS6euuw5
15EyVP8AyWw82FCTi8JNV9YxLHx28ydvzkIza2SRmEP3volKxO7dN5tHVorJI0QMx/UVHxwxy7lL
4pjZLdl/9DP8yJsFnfJVBRdFXBYlaxGatLQpw5QTaT0vftdWDSE7YRa+Lei9bRqbOYnMwgaRKxcy
0IlFBz5BJRuoQEuGa2U3DdwimiTER7856HXMQpTG1plCIOywFKymxwFL2efo+G3JKGgR6Cq+W3EI
jDuCgZY8Tk4xNTVd3q1ZuSLZu6XRXW0TyifBD5CeaHNvJ1A3NTtZRa1N6HQtVGqrEW5/WvdNTdqp
TKd6JR3etc2FoW02F5aZIYSydxkRhXJTGWfkTT69+UXkC0LAh1fRCU2C7zPbRmtFxefP6ZtYPUT+
9a/fS5lJKW3tUpEmsHZ2YknBibhAas803dIoa/i23UVST3ROhnkR5EeRHkR5E5KdDfGez7NvTpma
9Az+zonXk8oeMcr1pH6WteRQfQ9TZILIJHa3+piBKTZqeWkljTdw3TZrqLIZGhm22ftyspr5EqqA
4q7hqSNw2w3dL89day61+Maw4c7p56mVwmq2E2ow58J2IDqe+4Tar+CzMYurMobPX39sjZMOhumk
8Tw0eKrNd9XKJXuBfFH1hRAHmt2w5x5A6EaUz2J2/eRPnEjY76DUeIr7qOtRYOCRmAv5xU1nLYbV
McWXaoJPA+iq6DPVxrlDZfOiaJ1c+N/lS3eeSXVFhWdFKko0Z0pbccsaF8lUCeIyinufWkegASEH
HQmQOonXwolNraKh/wCckW4mPiRn7mdM6JrL5cOFUSJpx8dlqTusO3GQ6XRyubymfb8o7K4wtRhs
tIP85mjek6sryKvZcMVbMdMjJZpHD8ckgzGXKTmNGV8Y22UU1wmiVYNfEv0dNYE7iRQzWEeIo/Fb
8bnM4dxiUS1YOt0pxJfkgvw0CLO44zDSkdVEmKthgzBwevqWTaul10W2FkE9VESRleCL7t6pehT8
k5wpznm6rIR5ngsSHrdP3P05OH0KpzoyNXROVZldNgZRCM4gQVYuF4yCGx9J02cfnWeu/vf/AKzR
Eydw8VdbP+x5FYVB17E6MUnt6VhaRrrenOtLkrmOnq/h5KDKS6J9IcKKsjtW35bEjh8XIRrU3hZq
1fj3rJddZioxykoianRfxqXLSlhAqE3pSrLH5tifUB3ooN0hYfUvQbworDDF4meig0GX5DBvhFfr
3nBrFKJID5GoR1jOyTFAyswWffkHbokwV5wFe0X5x44q4hmB6SqkPk8sLrywNmchdbjF6ulPQPTd
msdhDz+ER3Jy3aPW0J/K03SRTw51X0/NnCeu26J2w8iPIjyI8iPInDLpPqfpCk/l0psQznTt1xat
VXNlWXbVWRcd3bB7J7Atzo2tqbuliYcMU5CgsPtKr43Gn6Oj3DXDE7+X8O2+mdvIlegHyozyB9Xf
IF0LbUsPPuIKu5ieTTn+oW4+NC13z6pemJRyoVnLKRP249Xbe9LiihLQY4IPNWDQNuyXU+zTO+2E
SyTP5pIQDDXWynMRqCX2VXFZ1TYMDjPKnTUb6QhtmHrntYZQ0LqF1YicHr5GDWancciEDniLoe5Y
4Fk0yjdwugmvomiQ1073H1dVUn7E1vOMyKj2FSc6cDSqNRbnq5ITOGr07dnaMyrCRzaE2XP6MavG
m5EUg0CHh5mJa5/THK/obabOUSGqJYzo35b2HMN0lIJZ0FpEFDxF2VjUWoR51pDHPVsnBWfI4jDR
dxRPmONwuSJawVtJJglumyMysPIHgho5faMdcaJILIkk/MHdszoPlGITKG2jPab0N9X8jVzOJ/Vw
NCS2GHq2yL8hMPsrSHA1IfPnBGQPIeVdptU2oYg82W21wggop9uuUSh9W/I0Qol92Pcgm5b8644K
58qmtg72a9LRCNU5bMZ7inFjBYuF5/jxWTVjQZ3aEH4lYEdJnismA5YxjL5qu3froLOW6CJPqvzQ
xOOV31OclcLp2ZTvmmqauubYbzN0wN6EqeSwezp5/mTt4ctwTWcZcV+rUks1y4mGroC6ywj2dCzL
D9HbZNNE2Y58uwOC88vLpmsZ51NKym+K156oGT0x2hWtpc1XRNbNFrG0Xr2/1ItFX1RBK7DiSz2U
qSSLtlGbMZncfqTVXRRyie6NfLE2lVa3kbAwmhZHOOf7SrKC2BKI72BAVOQgcJtmOOJRGrqL9RSC
JRxdrDxrcc7FlBDWJv5U1kCaLNMasg40e4RNHjfzKOZjX4F/X3P0cue05L3GR4Qj8dpHoARNaokc
9d84lujIXYwK5ClfRbClYkQbZs2OrOgjUjHsYfKZavFWabZ2iWFrXuroS0ZyS/qnG/8AZqQg/Q7T
lW0rKiN2sy81CWmFfMYjb04h9WE66j6Us5/p2zXK4kideHQx92wYOSbYDuknoioiVt4W+QLpAvXX
IO3QtTaHoD0ned388R3olzZgnFhE7GiMivw/EyRqkg1eMgwysDgCo3QcaUSke5TZRBu4cjEkXH5c
IndTyI8iUG6V+Pyt+oHPUC0zmMxC46d5fr7mkpvG/wCLav6/1q6b2rYsHtKEkXDRwu2n0cmNn4fs
1Fsbot3Qhqpprjb7s5RI3kfxRc/SsQ+iZk/OP6U74arjhluFHuRLMkKjFVzx1ZEPtYafUGul8WkM
l+6BDRwuiu02fNdFlEVM7Ka7ImRO/HpJ7lqe2606v6wtO9nVjiYONjZ0DEoBTQyqjFXTVtZNd2nD
obERb8GvdoqfDWJN6feZXbvNh7dskwaM8KNlESNJx8Ur26gt7rdCdZWjath9CwPmyvpfLm0HryER
6MBOYr7fXzDW1cwEIPXYx5oeNP1EC2jx4TXcKLKr6r6YyiggiYyx/iMazxK+YQw6jseF0VfnSYjr
mTVpH4BWm0nWu1jasQt58lIbcdiFJZMasXlEQR/TAPE8Ohzb8TRMjsOat2OiJf3p7mwB1BEa7iMi
khuLtq66BoLoMe8BIMF3JA7QFpRu0wYB5qQSWTTEHiUaTau908YX0QU2yntrv9M+RIDur456zu2c
9KSktOZvFgvU9a0xG7HjESTjzPZhbXOkx2l1JdFRQ2QEknA+zIT+Fkz3SdIvRRJqHHaOmyibX8ai
JmY9yNdytf2mFsruS7pVZtgtIYwjtmwaKVpU46sEYAfVkgh9FqxDgDcMJm5mQVylM1y2r5CRjvox
0QYM9dEdUSt4L4iIfhjZUyl1yvlOlpxZNHXFGb1qioKspkVVtm83t5uyqmXRKoQoo5EzJJ0Isc4M
lW59cupJRBHdltu2RSa4bom72F8b8wtqEwV1ZvW9gTLoKrehIx0xWVoEq7gX+UQawIhBj1cBgAXm
zVPMP/zvMZk75yu1VJqHFD62CepZNVJHRNE90G+MmPxifArQk182jYs6Z9pj+55EckrCKof2O0ku
UynKZGMosRQ1ozjtd7xklq+Hjmemu4zZsk21VVTxvvuiZlj8ehKP3AekcI6jueB8+zHonTrOZc3x
NIAGRMXooeGyw5q0uAe3a2MKpqczEUmYkUOwqs3KPlXCX7SI105HrIm1QrgCEQqreSasaT6WvhvI
3QJ3oOLlHLIIm+lp082u1ssAkCSDXRq1Doa3e8zps11TW+rJD65/6U+qJfzyI8iPIjyI8iPIjyI8
iPIjyI8iPIjyI8iPIjyJ/9k=

------=_NextPart_001_000B_01CA1A7A.7DC5D590--

------=_NextPart_000_000A_01CA1A7A.7DC5D590
Content-Type: application/vnd.ms-excel;
	name="DS4-nonserialized.csv"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="DS4-nonserialized.csv"

3000891|40708|58|5800.464|0|0||01/01/2001|0|5800.464|60|01/01/2002|||12/2=
006|0|0|0|0|0|0
3000892|40708|2|200.016|0|0||01/01/2001|0|200.016|60|01/01/2002|||12/2006=
|0|2|0|0|0|0
3000893|40708|73|7300.58|0|0||01/01/2001|0|7300.58|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000894|40708|200|15201.22|0|0||01/01/2001|0|15201.22|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000895|40708|20|1215.48|0|0||01/01/2001|0|1215.48|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000896|40708|117|7110.09|0|0||01/01/2001|0|7110.09|60|01/01/2002|||12/20=
06|0|117|0|0|0|0
3000897|40708|650|39645.42|0|0||01/01/2001|0|39645.42|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000898|40708|612|37322.99|0|0||01/01/2001|0|37322.99|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000899|40708|130|8039.02|0|0||01/01/2001|0|8039.02|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000900|40708|500|30919.29|0|0||01/01/2001|0|30919.29|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000901|40708|425|26281.39|0|0||01/01/2001|0|26281.39|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000902|40708|470|29244.25|0|0||01/01/2001|0|29244.25|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000903|40708|300|18590.29|0|0||01/01/2001|0|18590.29|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000904|40708|161|9716.36|0|0||01/01/2001|0|9716.36|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000905|40708|19|1146.65|0|0||01/01/2001|0|1146.65|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000906|40708|300|18830.03|0|0||01/04/2002|0|18830.03|60|01/04/2002|||03/=
2007|0|0|0|0|0|0
3000907|40708|1|859.96|0|0||01/09/2002|0|859.96|60|01/09/2002|||08/2007|0=
|0|0|0|0|0
3000908|40708|100|10878.08|0|0||01/12/2002|0|10878.08|60|01/12/2002|||11/=
2007|0|0|0|0|0|0
3000909|40708|50|5838.39|0|0||01/05/2003|0|5838.39|60|01/05/2003|||12/200=
7|50|0|0|0|0|0
3000910|40708|100|11421.78|0|0||01/07/2003|0|11421.78|60|01/07/2003|||12/=
2007|100|0|0|0|0|0
3000911|40708|95|10752.93|0|0||01/09/2003|0|10752.93|60|01/09/2003|||12/2=
007|95|0|0|0|0|0
3000912|40708|55|6218.62|0|0||01/09/2003|0|6218.62|60|01/09/2003|||12/200=
7|55|0|0|0|0|0
3000913|40708|61|6515.98|0|0||01/03/2004|0|6515.98|60|01/03/2004|||12/200=
7|61|0|0|0|0|0
3000914|40708|14|1499.7|0|0||01/04/2004|0|1499.7|60|01/04/2004|||12/2007|=
14|0|0|0|0|0
3000915|40708|150|17192.37|0|0||01/11/2004|0|17192.37|60|01/11/2004|||12/=
2007|150|0|0|0|0|0
3000916|40708|75|8697.47|0|0||01/11/2004|0|8697.47|60|01/11/2004|||12/200=
7|75|0|0|0|0|0
3000932|40707|183|11516.67495|0|0||01/01/2001|0|11516.67495|60|01/01/2002=
|||12/2006|0|0|0|0|0|0
3000933|40707|17|1069.85505|0|0||01/01/2001|0|1069.85505|60|01/01/2002|||=
12/2006|0|17|0|0|0|0
3000934|40707|26|1607.81|0|0||01/01/2001|0|1607.81|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000935|40707|105|6493.05|0|0||01/01/2001|0|6493.05|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000936|40707|200|12393.52|0|0||01/01/2001|0|12393.52|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000937|40707|198|11949.31|0|0||01/01/2001|0|11949.31|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000938|40707|8|494.55|0|0||01/01/2001|0|494.55|60|01/01/2002|||12/2006|0=
|0|0|0|0|0
3000939|40707|200|12704.33|0|0||01/01/2001|0|12704.33|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000940|40707|152|9393.54|0|0||01/02/2002|0|9393.54|60|01/02/2002|||01/20=
07|0|0|0|0|0|0
3000941|40707|48|2965.28|0|0||01/02/2002|0|2965.28|60|01/02/2002|||01/200=
7|0|0|0|0|0|0
3000942|40707|123|7653.29|0|0||01/01/2001|0|7653.29|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000943|40707|177|11013.26|0|0||01/01/2001|0|11013.26|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000944|40707|100|10878.08|0|0||01/12/2002|0|10878.08|50|01/12/2002|||01/=
2007|0|0|0|0|0|0
3000945|40707|75|8011.45|0|0||01/03/2004|0|8011.45|60|01/03/2004|||12/200=
7|75|0|0|0|0|0
3000946|40707|50|5478.61|0|0||01/09/2004|0|5478.61|60|01/09/2004|||12/200=
7|50|0|0|0|0|0
3000947|40707|89|10200.81|0|0||01/11/2004|0|10200.81|60|01/11/2004|||12/2=
007|89|0|0|0|0|0
3000948|40707|11|1275.63|0|0||01/11/2004|0|1275.63|60|01/11/2004|||12/200=
7|11|0|0|0|0|0
3000949|40707|30|3345.97|0|0||01/01/2005|0|3345.97|60|01/01/2005|||12/200=
7|30|0|0|0|0|0
3000950|40707|50|5595.84|0|0||01/02/2005|0|5595.84|60|01/02/2005|||12/200=
7|50|0|0|0|0|0
3000951|40707|26|2906.07|0|0||01/03/2005|0|2906.07|60|01/03/2005|||12/200=
7|26|0|0|0|0|0
3000952|40707|100|16026.36|0|0||01/05/2005|0|16026.36|60|01/05/2005|||12/=
2007|100|0|0|0|0|0
3000953|40707|200|22124.87|0|0||01/10/2005|0|22124.87|60|01/10/2005|||12/=
2007|200|0|0|0|0|0
3000954|40707|630|69527.22|0|0||01/07/2005|0|69527.22|60|01/07/2005|||12/=
2007|630|0|0|0|0|0
3000958|40728|127|26146.21199|0|0||01/01/2001|0|26146.21199|60|01/01/2002=
|||12/2006|0|0|0|0|0|0
3000959|40728|19|3911.638014|0|0||01/01/2001|0|3911.638014|60|01/01/2002|=
||12/2006|0|19|0|0|0|0
3000960|40728|389|80158.01|0|0||01/01/2001|0|80158.01|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000961|40728|61|12569.66|0|0||01/01/2001|0|12569.66|60|01/01/2002|||12/2=
006|0|61|0|0|0|0
3000962|40728|34|7106.43|0|0||01/01/2001|0|7106.43|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000963|40728|45|9562.05|0|0||01/01/2001|0|9562.05|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000964|40728|53|11261.54|0|0||01/01/2001|0|11261.54|60|01/01/2002|||12/2=
006|0|53|0|0|0|0
3000965|40728|118|24945.04|0|0||01/01/2001|0|24945.04|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000966|40728|20|5326.7|0|0||01/08/2005|0|5326.7|72|01/08/2005|||12/2007|=
20|0|0|0|0|0
3000967|40728|20|5297.31|0|0||01/07/2005|0|5297.31|72|01/07/2005|||12/200=
7|20|0|0|0|0|0
3000969|40728|100|26310.02|0|0||01/04/2006|0|26310.02|72|01/04/2006|||12/=
2007|100|0|0|0|0|0
3000970|40728|100|26428.23|0|0||01/04/2006|0|26428.23|72|01/04/2006|||12/=
2007|100|0|0|0|0|0
3000972|40791|561|19072.72|0|0||01/01/2001|0|19072.72|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000973|40791|400|13457.25|0|0||01/01/2001|0|13457.25|60|01/01/2002|||12/=
2006|0|0|0|0|0|0
3000981|40773|200|6563.98|0|0||01/01/2001|0|6563.98|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000982|40773|120|3998.77|0|0||01/01/2001|0|3998.77|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000983|40773|69|2340.59|0|0||01/01/2001|0|2340.59|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000984|40773|150|5292.92|0|0||01/01/2001|0|5292.92|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000985|40773|200|6640.53|0|0||01/01/2001|0|6640.53|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000986|40773|80|5947.41|0|0||01/01/2001|0|5947.41|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000987|40773|178|6940|0|0||01/01/2001|0|6940|60|01/01/2002|||12/2006|0|0=
|0|0|0|0
3000988|40773|122|4756.38|0|0||01/01/2001|0|4756.38|60|01/01/2002|||12/20=
06|0|122|0|0|0|0
3000989|40773|250|8554.34|0|0||01/01/2001|0|8554.34|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000990|40773|281|9615.09|0|0||01/01/2001|0|9615.09|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000991|40773|100|3460.21|0|0||01/01/2002|0|3460.21|60|01/01/2002|||12/20=
06|0|100|0|0|0|0
3000992|40773|168|5789.26|0|0||01/01/2002|0|5789.26|60|01/01/2002|||12/20=
06|0|0|0|0|0|0
3000993|40773|32|1114.47|0|0||01/01/2002|0|1114.47|60|01/01/2002|||12/200=
6|0|0|0|0|0|0
3000994|40773|66|2295.99|0|0||01/04/2002|0|2295.99|60|01/04/2002|||03/200=
7|0|0|0|0|0|0
3000995|40773|15|1085.34|0|0||01/07/2002|0|1085.34|60|01/07/2002|||12/200=
6|0|15|0|0|108.48|0
3000996|40773|15|1123.83|0|0||01/09/2003|0|1123.83|60|01/09/2003|||12/200=
7|15|0|0|0|0|0
3000997|40773|3|332.96|0|0||01/09/2004|0|332.96|60|01/09/2004|||12/2007|3=
|0|0|0|0|0
3000998|40773|5|366.76|0|0||01/10/2004|0|366.76|60|01/10/2004|||12/2007|5=
|0|0|0|0|0
3000999|40773|50|1853.67|0|0||01/02/2005|0|1853.67|60|01/02/2005|||12/200=
7|50|0|0|0|0|0
3001000|40773|50|1855.4|0|0||01/03/2005|0|1855.4|72|01/03/2005|||12/2007|=
50|0|0|0|0|0
3001001|40773|5|368.85|0|0||01/03/2005|0|368.85|72|01/03/2005|||12/2007|5=
|0|0|0|0|0
3001002|40773|50|1842.16|0|0||01/08/2005|0|1842.16|72|01/08/2005|||12/200=
7|50|0|0|0|0|0
3001003|40773|200|7204.24|0|0||01/09/2005|0|7204.24|72|01/09/2005|||12/20=
07|200|0|0|0|0|0
3001004|40773|20|1434.54|0|0||01/10/2005|0|1434.54|72|01/10/2005|||12/200=
7|20|0|0|0|0|0
3001005|40773|150|5524.98|0|0||01/02/2006|0|5524.98|72|01/02/2006|||12/20=
07|150|0|0|0|0|0
3001006|40773|20|1434.66|0|0||01/07/2006|0|1434.66|72|01/07/2006|||12/200=
7|20|0|0|0|0|0
3001007|40773|100|3655.9|0|0||01/04/2006|0|3655.9|72|01/04/2006|||12/2007=
|100|0|0|0|0|0
3001008|40773|100|3458.61|0|0||01/01/2007|0|3458.61|72|01/01/2007|||12/20=
07|100|0|0|0|0|0
3001009|40773|20|1375.11|0|0||01/01/2007|0|1375.11|72|01/01/2007|||12/200=
7|20|0|0|0|0|0
3001012|40789|250|14221.42|0|0||01/08/2001|0|14221.42|72|01/08/2001|||07/=
2007|0|0|0|0|0|0
3001013|40789|200|11503.61|0|0||01/10/2001|0|11503.61|72|01/10/2001|||09/=
2007|0|0|0|0|0|0
3001016|40782|200|2,183.23|0|0||01/03/2001|0|2,183.23|72|01/03/2001|||02/=
2007|200|0|0|0|0|0
3001017|40782|130|1359.94|0|0||01/07/2001|0|1359.94|72|01/07/2001|||06/20=
07|130|0|0|0|0|0
3001018|40782|26|1526.20|0|0||01/12/2005|0|1526.20|72|01/12/2005|||12/200=
7|26|0|0|0|0|0
3001019|40782|16|182.23|0|0||01/12/2005|0|182.23|72|01/12/2005|||12/2007|=
16|0|0|0|0|0
3001021|40782|480|5506.29|0|0||01/04/2006|0|5506.29|72|01/04/2006|||12/20=
06|0|0|0|480|0|4818.24
3001023|40686|200|28614.19|0|0||25/04/2006|0|28614.19|72|01/06/2006|||12/=
2007|200|0|0|0|0|0
3001024|40686|1|41.24|0|0||23/05/2006|0|41.24|72|01/07/2006|||12/2007|1|0=
|0|0|0|0

------=_NextPart_000_000A_01CA1A7A.7DC5D590--




From shoaibmir@gmail.com Tue Aug  11 04:22:13 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E6134633FF1
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 01:22:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 46772-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 04:22:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f217.google.com (mail-gx0-f217.google.com
	[209.85.217.217])
	by mail.postgresql.org (Postfix) with ESMTP id DAF0A633FC7
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 01:22:10 -0300 (ADT)
Received: by gxk17 with SMTP id 17so4209931gxk.19
	for <pgsql-sql@postgresql.org>; Mon, 10 Aug 2009 21:22:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=824ZZu8azEQCPCKU+yohl/kllBg9CFa3EGtBUCAF7VE=;
	b=pCBOxyxYrYJzrlV6NLX0v0uz/lOrn/6Vh4AtcaClbZGyvLtQ0fMhDyKBEoWGlBI/B2
	5wy+/+9YIhJA1Qt+BPhLDM+2iB3M5iZPVkDVJDZqf+3eknyu/tZi73eW+gWNa74f6FD8
	yehiOdAnopWCx53zwjHu9UcqSyaznmiuoYLwI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=dR/WK1SiJMRklEbZuaWch+mAAxg7qN1MWB8gJ9fIkrg1fXZV1yIQIBtUjQtHPDB2a9
	C5zP5UD2x3mE0Emh5vsJdmEBAFHDDUSNEWIQQX+P9xEP9KdAKZCP7Eqz6D/PI/IOcMsE
	dEwyjMZyHUcx/QlMwbhc6oxRyxigtcgibBH6c=
MIME-Version: 1.0
Received: by 10.90.90.6 with SMTP id n6mr4736023agb.60.1249964530272; Mon, 10
	Aug 2009 21:22:10 -0700 (PDT)
In-Reply-To: <-1997739725851209684@unknownmsgid>
References: <-1997739725851209684@unknownmsgid>
Date: Tue, 11 Aug 2009 14:22:10 +1000
Message-ID: <bf54be870908102122q43e66febj93fefb7f46541b3b@mail.gmail.com>
Subject: Re: Import (.CVS File) to postgreSql
From: Shoaib Mir <shoaibmir@gmail.com>
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0016364ed0d0cf0a640470d60b41
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5
	tests=BAYES_05=-1.11, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/37
X-Sequence-Number: 32946

--0016364ed0d0cf0a640470d60b41
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi <
premiladevi.dayalan@agbnielsen.com> wrote:

>  Dear All,
>
>
>
> I like to import (.CVS File) to postgreSql.Could anyone help me. May I
> know, what the requirement.
>
>
>

COPY command should be your friend in that case -->
http://www.postgresql.org/docs/8.3/static/sql-copy.html

-- 
Shoaib Mir
http://shoaibmir.wordpress.com/

--0016364ed0d0cf0a640470d60b41
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi <span dir=3D"ltr">&lt;<a href=
=3D"mailto:premiladevi.dayalan@agbnielsen.com">premiladevi.dayalan@agbniels=
en.com</a>&gt;</span> wrote:<br><div class=3D"gmail_quote"><blockquote clas=
s=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margi=
n: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">










<div link=3D"blue" vlink=3D"purple" lang=3D"EN-MY">

<div>

<p><span style=3D"font-size: 8pt;">Dear All,</span></p>

<p><span style=3D"font-size: 8pt;">=A0</span></p>

<p><span style=3D"font-size: 8pt;">I like to import (.CVS File)
to postgreSql.Could anyone help me. May I know, what the requirement.</span=
></p>

<p><span style=3D"font-size: 8pt;">=A0</span></p></div></div></blockquote><=
div><br>COPY command should be your friend in that case --&gt; <a href=3D"h=
ttp://www.postgresql.org/docs/8.3/static/sql-copy.html">http://www.postgres=
ql.org/docs/8.3/static/sql-copy.html</a><br>
=A0<br></div></div>-- <br>Shoaib Mir<br><a href=3D"http://shoaibmir.wordpre=
ss.com/">http://shoaibmir.wordpress.com/</a><br>

--0016364ed0d0cf0a640470d60b41--



From shoaibmir@gmail.com Tue Aug  11 04:58:44 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D908A633177
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 01:58:44 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 05974-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 04:58:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yw0-f199.google.com (mail-yw0-f199.google.com
	[209.85.211.199])
	by mail.postgresql.org (Postfix) with ESMTP id EB41B6330CA
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 01:58:33 -0300 (ADT)
Received: by ywh37 with SMTP id 37so5364394ywh.28
	for <pgsql-sql@postgresql.org>; Mon, 10 Aug 2009 21:58:33 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=7jdJ7Td0l5wvCguUAQOSk451yFcF63yD4K5oTh5hLtI=;
	b=EPcWBlbE+Rrym6ykk1PBVqjOJqm4qc11dx6FMryBOnAp6z4Ac5gsvi6VdmmOCr0fn0
	v3vvVgMY2G7p7fdjp1ek3fL3SmcxtbDqsK3ulbKZSXqrB1Ant+9X91oEvUzDfoAAmsOT
	vnkF733GKRby9DlrWP6hm400t1wZdvzn8+Mfk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=Mx6D0X1IOMJ16jLz6oURv7ORygLU2UtoL+U6WwO7+KqgnMhiDX3/BtAGQ8D5TBUpqp
	fQ4OH4v71YljiJkBh01vz/7kwNXyxE9ebVdJeGyX5893ICJ47dWkyNQr+PMEsb6XG6eA
	BVhAjBjHvOFRUzHZdfwo3fTB7/D9/tujmMR/U=
MIME-Version: 1.0
Received: by 10.90.87.19 with SMTP id k19mr4706575agb.55.1249966713251; Mon,
	10 Aug 2009 21:58:33 -0700 (PDT)
In-Reply-To: <2852095227642493290@unknownmsgid>
References: <-1997739725851209684@unknownmsgid>
	<bf54be870908102122q43e66febj93fefb7f46541b3b@mail.gmail.com>
	<2852095227642493290@unknownmsgid>
Date: Tue, 11 Aug 2009 14:58:33 +1000
Message-ID: <bf54be870908102158k53eedf2dg5aa490fd547e18e3@mail.gmail.com>
Subject: Re: Import (.CVS File) to postgreSql
From: Shoaib Mir <shoaibmir@gmail.com>
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=0016361e7f80ecaccc0470d68dd7
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.308 tagged_above=-10 required=5 tests=AWL=-0.315,
	BAYES_00=-2.599, DEAR_SOMETHING=1.605, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/38
X-Sequence-Number: 32947

--0016361e7f80ecaccc0470d68dd7
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi <
premiladevi.dayalan@agbnielsen.com> wrote:

>  Dear Sir,
>
>
>
> I am really don=92t understand Sir. May I have a screenshot on how to mak=
e
> these configuration sir.
>
>
>
> The File is in CVS, as I attached before sir.
>
>
>
As I told you before just use the COPY command. You don't need to do any
configurations and all.. just use the CSV option with COPY as explained in
the manual. Its just like any other SQL statement once you have the databas=
e
server installed.


Please do not post privately to my email as its always better posting it to
the list.

--=20
Shoaib Mir
http://shoaibmir.wordpress.com/

--0016361e7f80ecaccc0470d68dd7
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi <span dir=3D"ltr">&lt;<a href=
=3D"mailto:premiladevi.dayalan@agbnielsen.com">premiladevi.dayalan@agbniels=
en.com</a>&gt;</span> wrote:<br><div class=3D"gmail_quote"><blockquote clas=
s=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margi=
n: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">










<div link=3D"blue" vlink=3D"purple" lang=3D"EN-MY">

<div>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);">Dear Sir,</spa=
n></p>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);">=A0</span></p>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);">I am really do=
n=92t understand Sir. May I have a screenshot on how
to make these configuration sir.</span></p>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);">=A0</span></p>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);">The File is in=
 CVS, as I attached before sir.</span></p>

<p><span style=3D"font-size: 11pt; color: rgb(31, 73, 125);"><br></span></p=
></div></div></blockquote></div><br>As I told you before just use the COPY =
command. You don&#39;t need to do any configurations and all.. just use the=
 CSV option with COPY as explained in the manual. Its just like any other S=
QL statement once you have the database server installed.<br>
<br><br>Please do not post privately to my email as its always better posti=
ng it to the list.<br><br>-- <br>Shoaib Mir<br><a href=3D"http://shoaibmir.=
wordpress.com/">http://shoaibmir.wordpress.com/</a><br>

--0016361e7f80ecaccc0470d68dd7--



From andreas.kretschmer@schollglas.com Tue Aug  11 05:12:35 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 84F96632CE1
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 02:12:35 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 07909-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 11 Aug 2009 05:12:23 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by mail.postgresql.org (Postfix) with ESMTP id 97CE06328C9
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 02:12:24 -0300 (ADT)
Received: from webserv.wug.de ([194.25.154.138])
	by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis)
	id 0MKv5w-1Majeo2ZIO-000bhe; Tue, 11 Aug 2009 07:12:23 +0200
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1Majen-0000aa-00
	for pgsql-sql@postgresql.org; Tue, 11 Aug 2009 07:12:21 +0200
Date: Tue, 11 Aug 2009 07:12:21 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: Import (.CVS File) to postgreSql
Message-ID: <20090811051221.GA1068@a-kretschmer.de>
References: <000901ca1a37$6fa29590$4ee7c0b0$@dayalan@agbnielsen.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000901ca1a37$6fa29590$4ee7c0b0$@dayalan@agbnielsen.com>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
User-Agent: Mutt/1.5.9i
X-Provags-ID: V01U2FsdGVkX1/FYaG/z8Scb9b53+A3Z5i/PwbJTBLSAfTJJDY
	dcCrFwGXW92EzrauwoVuo1aQK0Ddv+de1ljUzzFxHmALNfGZrB
	q88iZoY4YJQDngM7+8qlg==
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.483 tagged_above=-10 required=5 tests=AWL=0.627,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 200908/39
X-Sequence-Number: 32948

In response to Premila Devi :
> Dear All,
> 
>  
> 
> I like to import (.CVS File) to postgreSql.Could anyone help me. May I know,
> what the requirement.

You can use the COPY-command for that, see the doc.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net