how to use "text" type data - Mailing list pgsql-sql

From 송기원
Subject how to use "text" type data
Date
Msg-id 000301be1105$af2811a0$4157fbcb@m2000.www.m2000.co.kr
Whole thread Raw
List 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!!



pgsql-sql by date:

Previous
From: Marc Howard Zuckman
Date:
Subject: Re: [SQL] abusing an aggregate funct
Next
From: Postgres DBA
Date:
Subject: Re: [SQL] abusing an aggregate funct