Dealing with spaces in DB and field names

I have a database with a schema like:

CREATE TABLE "Authorization Tokens" (
   "User Name" TEXT

I’m having trouble inserting a map into this table. What’s the JDBC line I want to insert some value into this table, given the spaces in table name and field name?

Assuming you’re using, – you want :entities (jdbc/quoted :ansi) (depending on the database you’re using – but you’re showing ".." which is ANSI style).

If you’re using next.jdbc, – you want :column-fn next.jdbc.quoted/ansi

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.