Re: Make MS Access "UPDATE" PostGre SQL Table
От | Daniel Verite |
---|---|
Тема | Re: Make MS Access "UPDATE" PostGre SQL Table |
Дата | |
Msg-id | 30e3e75c-2785-415f-917a-0259bfb56ffb@mm обсуждение исходный текст |
Ответ на | Re: Make MS Access "UPDATE" PostGre SQL Table (Justin <justin@emproshunts.com>) |
Ответы |
Re: Make MS Access "UPDATE" PostGre SQL Table
|
Список | pgsql-general |
Justin wrote: > Another option is use SQL pass through to append records from ACCESS > table into Postgres table that is open in Access. > http://support.microsoft.com/kb/303968 > http://msdn2.microsoft.com/en-us/library/bb208861.aspx > the command would look something like this > > Insert into PosgresTable (f1, f2, f3,) Select f1, f2, f3 from AccessTable It seems to me that SQL pass-through is kind of contrary to what the OP needs. A query in SQL pass-through mode will be executed as if it was typed in psql, that's the point of this mode. So refering to an Access table like your example query does is not going to work. What the OP can do is attach the CSV file in Access so that it will appear as a table and should be usable as such in an update or insert query within Access query builder. It's quite straightforward, there's no need for temp files or COPY. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-general по дате отправления: