[SQL] PostgreSQL is hanging up !?

2004-05-27 Thread Louie Kwan
2162 0 16:17 ?00:00:00 postgres: dcenter eocdb 206.116.78.128 DROP VIEW waiting root 17269 3236 0 16:26 pts/300:00:00 grep post Louie Kwan [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked ou

[SQL] IMPORT TOOL

2004-03-11 Thread Louie Kwan
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

[SQL] SYSDATE in PostgreSQL !?

2004-03-01 Thread Louie Kwan
, statusINTEGER NOT NULL, remedyID VARCHAR2(15) UNIQUE, remedySchemaID NUMBER default 48, remedyLastModifiedINTEGER, updateTimeStamp DATE default (SYSDATE), createTimeStamp DATE default (SYSDATE) ); Regards, Louie Kwan