unsubscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
hello
when selecting in a table with a text[]
there's an sql command for looking all dimensions of the array
something like 'where text[*]'
or only should be implemented trought a 'for (i=0; ihttp://archives.postgresql.org
hello,
trying to migrate production servers form 7.0.2 to 7.1.1 now I need to
compile an function written in c and when compiling using following
includes:
#include
#include
#include
#include
I get following compile errors:
c:82: warning: passing arg 1 of `textout' from incompatible pointe
how could I handle this when importing ?
bests from barcelona,
jaume teixi
ps: weather loops between 5ºC to 30ºC, crazy.
On Mon, 26 Feb 2001 22:16:35 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Jaume Teixi <[EMAIL PROTECTED]> writes:
> > I finally percated that when data contains 'ñ' or 'à' it's impossible
to
> > parse trought:
>
> > COPY product
I finally percated that when data contains 'ñ' or 'à' it's impossible to
parse trought:
COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g
it causes:
SELECT edicion FROM products;
edicion
-
España|Nacional <---puts on the same cell either th
ll
el Bulli taller
ICC
Ferran Adrià|Francés|Francia <---puts on the same cell 2 '|'
Also have tried with @ or tabs as delimiters with any result at all!!
why this only occurs on some cells? what more could I check?
best regards,
jaume.
> On 2/23/01 3:04 AM, "Jaume
Hi,
my customers have his local m$ access db's locally then export them on
.txt with tab or | separated, then put on my server trought ftp.
and is working ok except that the customers are on spanish databases then
a data like:
--DATE-NAME-LANG--
1/6/2000|Ferran Adrià|Castellano|