Received: from ns1.prima.net.id ([202.57.0.8])
	by hub.org (8.9.2/8.9.1) with ESMTP id BAA38337
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 29 Mar 1999 01:46:34 -0500 (EST)
	(envelope-from chairudin@prima.net.id)
Received: from prima.net.id (mail.prima.net.id [202.57.0.8]) by
	ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id UAA28228 for
	<pgsql-interfaces@postgreSQL.org>;
	Mon, 29 Mar 1999 20:46:46 +0700 (GMT)
Sender: root@ns1.prima.net.id
Message-ID: <36FF8446.2DC1D3F1@prima.net.id>
Date: Mon, 29 Mar 1999 06:46:46 -0700
From: Chairudin Sentosa <chairudin@prima.net.id>
Reply-To: chairudin@prima.net.id
Organization: PT. Khasanah Timur Indonesia
X-Mailer: Mozilla 4.5 [en] (X11; I; SunOS 5.5.1 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Update Postgresql auto from SQL Server 6.5
References: <199903290210.LAA00030@kmail.com> <36FF1CC9.3DE5BE66@flex.ro>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi friends,

I have a Linux + Postgresql machine and an SQL Server 6.5 machine.
There is one table (usage-detail) in SQL Server keeps getting data every seconds.

Now, I want data from table (usage-details) in SQL Server to show up in postgresql in real time (if possible).

What I am doing now is:
1. Spool the table (usage-details) from SQL Server 6.5 every 30 minutes.
2. Ftp the file to Linux machine
3. Use perl to run 'insert' command to insert data to table (usage-details) in Postgresql.

I would like to do it automatically, without doing any spooling or ftping.
How to do it?
I want that one table (usage-details) keeps synchronized  between postgresql and SQL Server 6.5

Can anyone help me, please?

Thank you for your help.

Regards,
Chai