RE: Access using Postgres - Mailing list pgsql-interfaces

/' does not work in Access.  The following does work using VBA in Access with PostgreSQL:

DoCmd.RunSQL "update Attributes set [note] = 'can''t' where AttributesID = 31"
or
DoCmd.RunSQL "update Attributes set [note] = ""can't"" where AttributesID = 31"


Thanks, Michael

-----Original Message-----
From:    Thomas Lockhart [SMTP:lockhart@fourpalms.org]
Sent:    Wednesday, January 03, 2001 7:17 AM
To:    Joseph
Cc:    pgsql-interfaces@postgresql.org
Subject:    Re: Access using Postgres

> Does anyone have a utility in access to add backslashes to single quotes for
> the odbc connection to postgres?

Does Access support the SQL9x standard of using two adjacent single
quotes to represent an embedded single quote? PostgreSQL recognizes that
syntax in addition to the backslashed form...
                         - Thomas