DDL import question

Поиск

Список

Период

Сортировка

От	Long Island Vision Management
Тема	DDL import question
Дата	11 сентября 2002 г. 16:02:34
Msg-id	000001c259ce$28b23d60$b392ffcc@mhegarty обсуждение исходный текст
Список	pgsql-admin

Дерево обсуждения

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

В списке pgsql-admin по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

DDL import question