summaryrefslogtreecommitdiff
path: root/contrib/oracle/ora2pg.pl
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2001-05-13 02:10:00 +0000
committerBruce Momjian <bruce@momjian.us>2001-05-13 02:10:00 +0000
commit904ba3ff69e1402bc2042807fd1d37f8570bfea1 (patch)
tree0abff2f3a24df1af18e97b74ddcbba5747540086 /contrib/oracle/ora2pg.pl
parent911a4981763cba58548139dc5c097d8961310d86 (diff)
downloadpostgresql-904ba3ff69e1402bc2042807fd1d37f8570bfea1.tar.gz
Update to ora2pg 1.2.
Diffstat (limited to 'contrib/oracle/ora2pg.pl')
-rwxr-xr-xcontrib/oracle/ora2pg.pl8
1 files changed, 7 insertions, 1 deletions
diff --git a/contrib/oracle/ora2pg.pl b/contrib/oracle/ora2pg.pl
index 00830694cc..8b8e530235 100755
--- a/contrib/oracle/ora2pg.pl
+++ b/contrib/oracle/ora2pg.pl
@@ -20,7 +20,7 @@ use strict;
use Ora2Pg;
# Initialyze the database connection
-my $dbsrc = 'dbi:Oracle:host=aliciadb.samse.fr;sid=ALIC;port=1521';
+my $dbsrc = 'dbi:Oracle:host=test.mydomain.com;sid=TEST;port=1521';
my $dbuser = 'system';
my $dbpwd = 'manager';
@@ -29,6 +29,12 @@ my $schema = new Ora2Pg (
datasource => $dbsrc, # Database DBD datasource
user => $dbuser, # Database user
password => $dbpwd, # Database password
+ debug => 1, # Verbose mode
+# type => 'VIEW', # Extract views
+# tables => [('MY_TABLE1','MY_TABLE2')], # Extract only these table
+# showtableid => 1, # Display only table indice during extraction
+# min => 1, # Extract begin at indice 1
+# max => 10 # Extract ended at indice 10
);
# Create the POSTGRESQL representation of all objects in the database