pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to use text type field....
2+ messages / 2 participants
[nested] [flat]
* How to use text type field....
@ 1998-11-17 05:58 ¼Û±â¿ø <schiva@m2000.co.kr>
1998-11-17 10:12 ` Re: [SQL] How to use text type field.... Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 1 reply; 2+ messages in thread
From: ¼Û±â¿ø @ 1998-11-17 05:58 UTC (permalink / raw)
To: PostgreSQL-user <pgsql-sql@postgresql.org>; PostgreSQL-question <questions@postgresql.org>; PostgreSQL-other <pgsql-novice@postgresql.org>; PostgreSQL-hacker <pgsql-hackers@postgresql.org>; PostgreSQL-General <pgsql-general@postgresql.org>; pgsql-interfaces; PostgreSQL-ADMIN <pgsql-admin@postgresql.org>
Hi~ Everyone...
I have some problem... with PostgreSql Version 6.4
I don't know how to use text type data filed...
Hm...
---------------------------------------------------------------
create table test(
id int primary key,
data1 text)
How to use "insert into test........" ??
How to use "update test ....." ???
data1 size is so!!! Big....~~~ Can't execute query...in C Language....
Do you have some sample code with C Language...???
Anybody.... Please.. Help me...!!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] How to use text type field....
1998-11-17 05:58 How to use text type field.... ¼Û±â¿ø <schiva@m2000.co.kr>
@ 1998-11-17 10:12 ` Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 0 replies; 2+ messages in thread
From: Herouth Maoz @ 1998-11-17 10:12 UTC (permalink / raw)
To: schiva@m2000.co.kr; +Cc: pgsql-sql@postgreSQL.org
At 7:58 +0200 on 17/11/98, =?euc-kr?B?vNux4r/4?= wrote:
>
> Hi~ Everyone...
>
> I have some problem... with PostgreSql Version 6.4
>
> I don't know how to use text type data filed...
>
> Hm...
> ---------------------------------------------------------------
> create table test(
> id int primary key,
> data1 text)
>
> How to use "insert into test........" ??
> How to use "update test ....." ???
>
> data1 size is so!!! Big....~~~ Can't execute query...in C Language....
>
> Do you have some sample code with C Language...???
>
> Anybody.... Please.. Help me...!!
Text type is nothing special. You just use
INSERT INTO TEST (id, data1)
VALUES ( 12345, 'This is the text I wanted to Enter' );
and
UPDATE TEST
SET data1 = 'This is the new text I wanted to Enter';
That's all there is to it. Put the text within single quoute. Escape single
quotes within the text by doubling them ('' instead of '). The text may
include newlines and everything:
INSERT INTO TESTE (id, data1)
VALUES (
123456,
'This is a three-line
text field
within the table' );
Just remember not to pass the maximum row size, which I believe is still 8k
for all the fields together.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-11-17 10:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-17 05:58 How to use text type field.... ¼Û±â¿ø <schiva@m2000.co.kr>
1998-11-17 10:12 ` Herouth Maoz <herouth@oumail.openu.ac.il>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox