[GENERAL] More than one characters in DELIMITER (for COPY)

2007-07-25 Thread L. Berger
Hi, We have data where all the characters on the keyboard are used. The data is utf-8, so all of those European characters with umlauts and such are also used. Because of this we have {~} as the delimiter, even {} was taken! Now when I try to specify this delimiter in the COPY command to import t

Re: [GENERAL] SQL Manager 2007 for PostgreSQL released

2007-05-28 Thread L. Berger
On May 23, 8:47 am, "EMS Database Management Solutions (SQLManager.net)" <[EMAIL PROTECTED]> wrote: > We, here at EMS Database Management Solutions, are pleased to announce > SQL Manager 2007 for PostgreSQL - the new major version of the > powerful PostgreSQL administration and development tool! >

[GENERAL] TWO SAME TABLES, ONE UPDATED. HOW TO SYNC THE OTHER?

2007-05-12 Thread L. Berger
Hello I have two tables -- A and B. The structure of both is the same. Only, B has many indexes and is used for heavy duty SELECTs. On the other hand, A only accepts heavy duty INSERTs, so has only one primary key index. So my DB design is such that A is only an INSERT table. Periodically, say ev