I have created several domains at Postgresql and I am trying to create some
views on a domain dcenter using
create or replace view cw_nodir_v
as
select ...
However, my PostgreSQL hangs up.. on this domain only but not in other
domains...
Don't want to reboot PQ, and methods I can find out the
postgresql server.
Is there a way to SELECT tables or create JOINs from multiple databases JDBC
or psql . I aware that Oracle has Database Link concept.
Any tip will help. I did some search on previous posting, but cannot find
much.
Louie Kwan
NUVO - THE IT OUT-TASKING COMPANY
(613) 726-5071
Hi All,
Do anyone of you aware of any good 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
regards,
Louie Kwan
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
We are looking for some sort of commercial PostgreSQL support, but we have
limited budget.
Email based type support may be enough.
Any pointer will be appreciated.
Thanks.
Regards,
Louie Kwan
---(end of broadcast)---
TIP 3: if posting/reading
,
statusINTEGER NOT NULL,
remedyID VARCHAR2(15) UNIQUE,
remedySchemaID NUMBER default 48,
remedyLastModifiedINTEGER,
updateTimeStamp DATE default (SYSDATE),
createTimeStamp DATE default (SYSDATE)
);
Regards,
Louie Kwan
Louie Kwan would like to recall the message, SELECT ANY TABLE !!.
---(end of broadcast)---
TIP 8: explain analyze is your friend
I would like to create a user with only read privilege, something like
SELECT ANY TABLE...
Any pointer or help is appreciated.
Louie Kwan
[EMAIL PROTECTED]
NUVO - THE IT OUT-TASKING COMPANY
(613) 726-5071Direct Line
(613) 721-1399 Fax
---(end