I'm using pg_dump as a data transfer tool to input data to m$sql.
why I can not use copy and then m$sql's bcp? because m$sql
strangly ignore the difference between null and empty string
(in bcp's input format, no quotation mark used, just like pg.
however, it has no escape for null.).
so, I u
Thank you Ed,
>IIRC, this is a known issue with 'IN', and that the traditional
>solution was to replace use of 'IN' with 'EXISTS', i.e.,
>
> and EXISTS (select * from userdir where user_name = username and
>towncode...)
>
>Cheers,
>Ed Loehr
>
>
>
>
> I have been reading in the doc directory of the 6.5.1 tree for information
> about UNICODE and UTF-8 support and still have a few questions.
> It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are
> available and working okay at this time. Can anyone explain?
As stated i
I have been reading in the doc directory of the 6.5.1 tree for information
about UNICODE and UTF-8 support and still have a few questions.
It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are
available and working okay at this time. Can anyone explain?
I get the impress
Hello Marco,
Once, Monday, February 14, 2000, 4:11:25 PM, you wrote:
MG> I'm really a novice on postgresql but i'm using it on a linux server and
MG> i find it really usefull.
MG> Now I'd like to convert from MS Access some tables to use them with
MG> postgresql.
MG> I'm sure must exists a tutor
I have a table with a few indexes, which I thought were going to speed up
queries using the indexed columns. however, this doesn't appear to be the case.
I've got something like this, but with more columns:
create table jnl_refs (
ref_article varchar(26) not null,
ref_seqno integer not
I'm really a novice on postgresql but i'm using it on a linux server and
i find it really usefull.
Now I'd like to convert from MS Access some tables to use them with
postgresql.
I'm sure must exists a tutorial on it, or maybe some of you can give me
sone hints.
Thanks for replying
Marco
--
Hello All,
I am writing the second time about my problem, maybe this time
somebody will answer. The problem is following:
I use a cyrillic characters in the names of tables and fields. When
I use plpgsql function as a trigger I have a record NEW in this
function, and consequently this record has