Обсуждение: DDL import question

Поиск
Список
Период
Сортировка

DDL import question

От
"Long Island Vision Management"
Дата:
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