Received: from mail.m2000.co.kr (IDENT:root@[203.251.87.4]) by hub.org (8.9.1/8.9.1) with ESMTP id VAA07332; Sun, 15 Nov 1998 21:05:25 -0500 (EST) (envelope-from schiva@m2000.co.kr) Received: from m2000.www.m2000.co.kr ([203.251.87.65]) by mail.m2000.co.kr (8.9.1/8.8.8) with SMTP id LAA12058; Mon, 16 Nov 1998 11:26:37 +0900 Message-ID: <000301be1105$af2811a0$4157fbcb@m2000.www.m2000.co.kr> From: "=?euc-kr?B?vNux4r/4?=" To: "PostgreSQL-user" , "PostgreSQL-question" , "PostgreSQL-other" , "PostgreSQL-General" Subject: how to use "text" type data Date: Mon, 16 Nov 1998 11:06:06 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="euc-kr" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I want to put *.txt (ASCII PC Text file) to PostgreSQL Database..... (.. It's DB Data type is TEXT ) .. 1.How can i use sql sentence... EX) create table test ( pkey int primary key, data text); ??=>> insert into test (~~~~~??????) 2.How can i search TEXT type Data ... very highly speed...?? i want to search word with in Text type data.... Sorry for my poor English.... Have a nice day.. and Please.. Help me!!