creating postgres tables using existing table defs

Susan Lane wrote:

Hi -

I have just started the process of creating tables in Postgres and I
wondered if there was some way to take existing tables definitions in Oracle
and port them into Postgres. I have existing create table scripts, but some
of the syntax does not work for Postgres. Any easy way to do this without
having to rewrite my SQL?

Looked into contrib/oracle ?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

No I haven't......I just did a search at altavista, yahoo, and the Oracle
Technology Network and I can't find much about it (unless it's in German or
French!) Can you point me in the right direction?

Thanks!

Jan Wieck <JanWieck@Yahoo.com> wrote in message
news:200108011146.f71Bk9T01395@jupiter.us.greatbridge.com...

No I haven't......I just did a search at altavista, yahoo, and the Oracle
Technology Network and I can't find much about it (unless it's in German or
French!) Can you point me in the right direction?

Sure. Look in the PostgreSQL source tree. There is a /contrib
directory, and under that their is an /oracle directory. It is in
there. I think it converts Oracle dumps to PostgreSQL dumps.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From: "Bruce Momjian" <pgman@candle.pha.pa.us>

No I haven't......I just did a search at altavista, yahoo, and the

Oracle

Technology Network and I can't find much about it (unless it's in

German or

French!) Can you point me in the right direction?

Sure. Look in the PostgreSQL source tree. There is a /contrib
directory, and under that their is an /oracle directory. It is in
there. I think it converts Oracle dumps to PostgreSQL dumps.

Also - is there not some information on this in the techdocs.postgresql.org
part of the site (got a feeling Roberto Mello might have submitted it)

- Richard Huxton