Обсуждение: how to use "text" type data

Поиск
Список
Период
Сортировка

how to use "text" type data

От
"송기원"
Дата:
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!!