Re: [SQL] IMPORT TOOL

[EMAIL PROTECTED] (Louie Kwan) writes: > Do anyone of you aware of any PG import tool same as SQL*LOADER in ORACLE > > We are doing some DataWarehouse work and need to import a large set of data > from csv files. > > We are trying a import tool from ems-hitech.com, but I have troubles when > loadin

[SQL] Problems with tsearch2: ERROR: datumGetSize: Invalid typLen 0

Hi all - I'm playing with tsearch2. It built and installed normally (this is PG 7.3.2 on an Alpha running Debian Stable, with the December 18th tsearch2), and portions of it work, but, for instance ts_tsvector doesn't: jal=# select to_tsvector('default', 'Our first string used today first str

[SQL] IMPORT TOOL

Hi All, Do anyone of you aware of any PG import tool same as SQL*LOADER in ORACLE We are doing some DataWarehouse work and need to import a large set of data from csv files. We are trying a import tool from ems-hitech.com, but I have troubles when loading time and date columns. Any help is much

Re: [SQL] About pg_dump

I've made a test and it seems ok to me. I'm using utf-8 encoding under postgresql 7.3.3. Tom Lane wrote: "Rute Solipa" <[EMAIL PROTECTED]> writes: it seems that the pg_dump command doesn't keep the encoding information. As of 7.4.2 it does emit a SET client_encoding. In prior release

Re: [SQL] Break a report in Run Time

On Thursday 11 March 2004 10:08 am, Jander wrote: > I need to abort the SQL process inside my application developed in Kylix. > Go read the documentation for Kylix. I don't know the environment at all. I do know that if you are calling the query in a blocking manner then the only way to stop it

[SQL] trace facility

Is there a trace facility that i can use with postgreSQL 7.3.4, ala SQLServer 2000? many thanks in advance ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not ma

Re: [SQL] Break a report in Run Time

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 11 March 2004 9:11 am, Jander wrote: > I need to abort the SQL process running in DB Server. > If you are in psql, you can cancel any query with CTRL-C. Otherwise, you can kill the process running the query using the "kill" c

Re: [SQL] designer tool connect to PostgreSQL

On Thu, 11 Mar 2004 [EMAIL PROTECTED] wrote: > Hi, > > thanks to all for the responnd...i've look into all the tools mentioned > and found many tools which has a great feautre such as designing/modelling > the object/table but it seems look like that there is no tools that can do > the ETL pr

Re: [SQL] About pg_dump

"Rute Solipa" <[EMAIL PROTECTED]> writes: > it seems that the pg_dump command doesn't keep the encoding information. As of 7.4.2 it does emit a SET client_encoding. In prior releases, if you are manually creating the destination database then you need to be careful to create it with the same enco

Re: [SQL] randomized order in select?

On Thu, 11 Mar 2004, Iain wrote: > If you have a lot of tips, you could create a unique indexed tip number > column. Select the highest tip number using: > > select tip_number from tips order by tip_number desc limit 1; > > Then generate a random number and select using that tip_number. > > Of

Re: [SQL] About pg_dump

hi, i had to restore a database from a pg_dump and i'm having problems with the encoding. it seems that the pg_dump command doesn't keep the encoding information. does anybody can help me resolve this problem. thanks rute - Original Message - From: "Daniel Henrique Alves Lima" <[EMAIL