msaccess to postgre
От | Peter Jackson |
---|---|
Тема | msaccess to postgre |
Дата | |
Msg-id | 478CB148.2090309@iprimus.com.au обсуждение исходный текст |
Ответы |
Re: msaccess to postgre
|
Список | pgsql-novice |
OK I'm currently trying to get my head around postgre, sql in general and php. So if this question seems easy dont mind me. What I wish to do is move several ms access dbases to postgre using ODBC connection. I have managed to do this but where I have hit a brickwall is trying to get it to add the tables to a different schema. I have a database called general in that database there are 4 schemas. accounts, production,maintenance and public. I have set the search path to production, accounts, maintenance, public. But the ODBC connection still saves it to the public schema. (I want it saved in this instance to production schema.) Yes the user I am connecting as has create privileges in production. Anyone got any suggestions or easier (non-commercial) way of doing it? Failing that is it possible to move/copy a table from one schema to another? thanks in advance
В списке pgsql-novice по дате отправления: