Thread: creating postgres tables using existing table defs
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? -- Susan Lane DPN, Incorporated 4631 Spring Mountain Road Las Vegas, NV 89102 Email suel@dpn.com Ph. (702) 873-3282 Fax (702) 873-3913 http://www.dpn.com
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... > Looked into contrib/oracle ? > > > Jan
> 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