hi everyone, I am trying to figure out how to import a DDL I got from one of out developers into a postgres DB. I am using linux RH 7.1 and version 7.2.2 or pgsql. The developers are using some visio and access tools to generate the database structures and DDL files and I want to import them to pgsql. Is it as simple as issuing something like the following
psql -U username dbname < file.ddl
I tried that and I am getting errors. Some are quote problems and others seem to be from the CREATE statements. I figure there has to be a script of some kind to do this type of import since DDL's are pretty standard. I read about a hack to work around this by setting up ODBC connections and stuff, but there has to be an easier way.
Thanks in advance for all you help
-Matt