Daniel Verite wrote:
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 th
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 Posg
Pettis, Barry wrote:
However, I am now in need of being able to update a PostGre table. The
source will be a .csv file.
I've seen a "COPY" command in PostGre that will allow you to
specify a .csv file as the source, but in looking at it it appears that
I'm using Access as
Pettis, Barry wrote:
Hi,
I'm fairly new to DBMS's and PostGre SQL in particular. Most
of my experience is with MS Access. I've created MS Access to
retrieve data from PostGre by linking tables and have done so without
error. However, I am now in need of being able to update a Po
___
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pettis, Barry
Sent: Monday, March 24, 2008 6:08 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Make MS Access "UPDATE" PostGre SQL Table
>>
Note:
Generally, it is best
On Mon, Mar 24, 2008 at 07:08:13AM -0600, Pettis, Barry wrote:
> I'm fairly new to DBMS's and PostGre SQL in particular. Most of
> my experience is with MS Access. I've created MS Access to retrieve
> data from PostGre by linking tables and have done so without error.
If you've linked th
Barry,
Per the COPY documentation:
*COPY moves data between PostgreSQL tables and standard file-system files. COPY
TO copies the contents of a table to a file, while COPY FROM copies data
from a file to a table (appending the data to whatever is in the table
already). *
...So it's not destructiv
Hi,
I'm fairly new to DBMS's and PostGre SQL in particular. Most of
my experience is with MS Access. I've created MS Access to retrieve
data from PostGre by linking tables and have done so without error.
However, I am now in need of being able to update a PostGre table. The
source will
