Loading text data/binary data !!

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4C671.A1EA786C
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello all,

2 questions !

Question 1
Iam trying to load binary data from sql server to postges. Do i have to
write a script .. ??

Question 2
How i do load text data with newlines into postgres database .. (as
newline is the default row delimiter and cannot be changed in the column
table).


Thanks !
Goutam


Confidentiality Notice
The information contained in this e-mail is confidential and intended for u=
se only by the person(s) or organization listed in the address. If you have=
received this communication in error, please contact the sender at O'Neil =
& Associates, Inc., immediately. Any copying, dissemination, or distributio=
n of this communication, other than by the intended recipient, is strictly =
prohibited.


------_=_NextPart_001_01C4C671.A1EA786C
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial><FONT size=3D2><SP=
AN
class=3D157493315-09112004><FONT
color=3D#0000ff>Hello all, </FONT></SPAN></FONT></FONT></SPAN></D=
IV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial size=3D2>2 questio=
ns
!</FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial size=3D2><STRONG>Q=
uestion
1</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial size=3D2>Iam tryin=
g to load
binary data from sql server to postges.  Do i have to write a script .=
..
??</FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial size=3D2><STRONG>Q=
uestion
2</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial size=3D2>How i do =
load text
data with newlines into postgres database .. (as newline is the default row=
delimiter and cannot be changed in the column table).</FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial color=3D#0000ff
size=3D2></FONT><BR><FONT face=3DArial><FONT size=3D2><SPAN
class=3D157493315-09112004><FONT color=3D#0000ff> </FONT></SPAN>Thanks=
!</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D035535219-08112004><FONT face=3DArial
size=3D2>Goutam</FONT></SPAN></DIV></DIV><FONT SIZE=3D3><BR>
<BR>
Confidentiality Notice<BR>
The information contained in this e-mail is confidential and intended for u=
se only by the person(s) or organization listed in the address. If you have=
received this communication in error, please contact the sender at O'Neil =
& Associates, Inc., immediately. Any copying, dissemination, or distributio=
n of this communication, other than by the intended recipient, is strictly =
prohibited.<BR>
</FONT>
</BODY></HTML>

------_=_NextPart_001_01C4C671.A1EA786C--
gparuchuri [ Di, 09 November 2004 16:34 ] [ ID #474024 ]
Datenbanken » comp.databases.postgresql.sql » Loading text data/binary data !!

Vorheriges Thema: Simple SQL Question
Nächstes Thema: tricky GROUP BY / JOIN question