how to use "text" type data

From: 송기원 <schiva(at)m2000(dot)co(dot)kr>
To: "PostgreSQL-user" <pgsql-sql(at)postgresql(dot)org>, "PostgreSQL-question" <questions(at)postgresql(dot)org>, "PostgreSQL-other" <pgsql-novice(at)postgresql(dot)org>, "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: how to use "text" type data
Date: 1998-11-16 02:06:06
Message-ID: 000301be1105$af2811a0$4157fbcb@m2000.www.m2000.co.kr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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!!

Browse pgsql-general by date

  From Date Subject
Next Message Memphisto 1998-11-16 11:16:51 postgreSQL startup on AIX4.2
Previous Message Herouth Maoz 1998-11-15 12:06:29 Re: [GENERAL] alter table ?

Browse pgsql-sql by date

  From Date Subject
Next Message sqyang2 1998-11-16 02:25:40
Previous Message Marc Howard Zuckman 1998-11-15 16:04:26 Re: [SQL] abusing an aggregate funct