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