<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks for the help with /dt... Mike, your post helped me to discover psql > command window, I had been trying out the pgAdmin ... > > I found an interesting article regarding MSAccess as a front end to > Postgresql, so I downloaded the psqlodbc installer. I will be getting up > the nerve > to run the install and go into windows odbc and install that driver so I > can > use MSAccess with Postgresql ... any tips or caveats appreciated....
Be sure to check out the FAQs and How-tos at the psqlodbc project site: http://gborg.postgresql.org/project/psqlodbc/projdisplay.php You will find that that Access and PostgreSQL get on well together. You can get by with the default driver settings for the most part; I suggest that you make sure that the "row versioning" and "true = -1" options are set to true. If you want to use the "memo" datatype in Access, then you will need to check "text = longvarchar" option. If you have further questions, try posting to the pgsql-odbc list. > > This is the link which is guiding me.... > _http://database.sarang.net/database/postgres/postodbc/faq.html_ > (http://database.sarang.net/database/postgres/postodbc/faq.html) > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]