From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
---|---|
To: | "Ken J(dot) Wright" <ken(at)ori-ind(dot)com>, pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] How to store ' |
Date: | 1999-05-11 09:16:50 |
Message-ID: | l03130300b35da5168862@[147.233.159.109] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
At 19:38 +0300 on 10/05/1999, Ken J. Wright wrote:
> But just to clarify further, that only works with sql. Copy needs the '\'
> approach.
> So many choices ;-)
Copy doesn't need it at all, because you don't have quotes around the
fields. The following is from my 6.4.2:
testing=> \d test
Table = test
+-----------------------------+-----------------------------+-------+
| Field | Type | Length|
+-----------------------------+-----------------------------+-------+
| t | text | var |
+-----------------------------+-----------------------------+-------+
testing=> copy test from stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>> This is a field without a quote.
>> Here the word 'field' is in quotes.
>> Isn't it nice to have one quote in this field?
>> \.
testing=> select * from test;
t
----------------------------------------------
This is a field without a quote.
Here the word 'field' is in quotes.
Isn't it nice to have one quote in this field?
(3 rows)
I hope this convinces you...
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 1999-05-11 10:11:42 | RE: [INTERFACES] Java and PGSQL date question |
Previous Message | Charles Stroom | 1999-05-11 07:16:44 | Re: [INTERFACES] Bug in psql? |