[SQL] COPY and UNICODE encoding

2001-02-19 Thread Alexaki Sofia
Hello, I am using jdbc interface to load my data and Postgresql 7.02. I want to use copy command to load data from a unicode file. How can I notify the server that the encoding of the file is unicode and not the default encoding of the file system. Thanks in advance Regards Sofia Alexaki

Re: [SQL] How to insert values with a new type ?

2001-02-19 Thread Tom Lane
[EMAIL PROTECTED] writes: complexe * complex_in(float x, float y) { complexe *result; result = (complexe *)palloc(sizeof(complexe)); result-x = x; result-y = y; return (result); } A datatype's input routine has to accept a string (char *).

Re: [SQL] Contributing Documentation to PG

2001-02-19 Thread Peter Eisentraut
Roberto Mello writes: I finally came around to writing some extra documentation for PL/PgSQL (and maybe PL/Tcl) and how to do PL/SQL-to-PL/PgSQL porting. I saw this on your site -- very nice. Can you give use the source code, so we can integrate it? I downloaded the