[HACKERS] unsubscribe

2004-04-13 Thread Jaume Teixi
unsubscribe ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] COPY as non super user

2003-01-31 Thread Jaume Teixi
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

[HACKERS] best method for select within all dimensions of an array

2002-04-08 Thread Jaume Teixi
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; imaxDimension; i++) ? bests from barcelona jaume teixi ---(end

[HACKERS] hacker mechanism for m$access - pgsql on different language systems

2001-02-23 Thread Jaume Teixi
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|

[ADMIN] Re: NOSUCCESS: m$ access - psql howto ?

2001-02-26 Thread Jaume Teixi
'|' 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 Teixi" [EMAIL PROTECTED] wrote: Hi, I cannot use any kind of odbc because my customers have h

[HACKERS] Re: SOLVED: COPY doesn't works when containing ' ' or ' ' characters on db

2001-02-27 Thread Jaume Teixi
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 products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g it causes

[ADMIN] Still some problems importing with COPY

2001-02-28 Thread Jaume Teixi
from barcelona, jaume teixi ps: weather loops between 5C to 30C, crazy.