Thanks a lot Anders.
Another query - i am sure someone has used this before. I want to try
out replication by creating my own class which implements Statement and
whenever an execute/executeUpdate is called, pass on the sql using TCP
to another application running on a different server which will execute
the sql on the slave DB.
I do understand that this replication using java would not be very good
in terms of performance. But i am not really sure i want to turn on
pgReplicator on my production DB.
Is there anything else i should worry about?
regards
vishnu
Anders Hermansen wrote:
>* Vishnu R (Vishnu_R@sifycorp.com) wrote:
>
>>Is there any nice way of getting a list of sequences from a db using jdbc?
>>
>
>Retreive the MetaData with:
>connection.getMetaData();
>
>The DatabaseMetaData object has a method getTables, check out the
>javadoc:
>http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html
>
>When you set the types parameter to SEQUENCE you will get sequences.
>
>
>Hope this helps,
>Anders
>
>--
>Anders Hermansen
>YoYo Mobile as
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>