Re: [HACKERS] postgresql and oracle, compatibility assessment

2003-02-17 Thread Martin Matusiak
Would it be possible to create some sort of transparent API based on ODBC to be used with PostgreSQL and Oracle? I know there exists a JDBC - ODBC bridge for java. Martin - Original Message - From: "Hannu Krosing" <[EMAIL PROTECTED]> To: "Martin Matusiak" <[

[HACKERS] pg environment? metadata?

2003-02-17 Thread Martin Matusiak
> Hello, > > I was wondering what kind of functions/constants exist in Postgre to dig up > metadata. I barely scratched the surface of Oracle but I know you find > things like user_tables there that can be used to extract info about your > tables. What I'm looking for is some kind of functions to

[HACKERS] postgresql and oracle, compatibility assessment

2003-02-17 Thread Martin Matusiak
le to imagine one could run dumps from Postgre into Oracle and vice versa? Alternatively, run separate queries on both to set the structure and relations, then transfer only data?   PostgreSQL 7.3 Oracle 8.x      Best regards,   Martin Matusiak