{"action":"created","issue":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/229","labels_url":"https://api.github.com/repos/javalite/activejdbc/issues/229/labels{/name}","comments_url":"https://api.github.com/repos/javalite/activejdbc/issues/229/comments","events_url":"https://api.github.com/repos/javalite/activejdbc/issues/229/events","html_url":"https://github.com/javalite/activejdbc/issues/229","id":27951346,"number":229,"title":"PostgreSQL's dialect of SQL - proper quoting identifiers like table or column names","user":{"login":"LukaszDargiewicz","id":6735953,"avatar_url":"https://avatars.githubusercontent.com/u/6735953?v=3","gravatar_id":"","url":"https://api.github.com/users/LukaszDargiewicz","html_url":"https://github.com/LukaszDargiewicz","followers_url":"https://api.github.com/users/LukaszDargiewicz/followers","following_url":"https://api.github.com/users/LukaszDargiewicz/following{/other_user}","gists_url":"https://api.github.com/users/LukaszDargiewicz/gists{/gist_id}","starred_url":"https://api.github.com/users/LukaszDargiewicz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LukaszDargiewicz/subscriptions","organizations_url":"https://api.github.com/users/LukaszDargiewicz/orgs","repos_url":"https://api.github.com/users/LukaszDargiewicz/repos","events_url":"https://api.github.com/users/LukaszDargiewicz/events{/privacy}","received_events_url":"https://api.github.com/users/LukaszDargiewicz/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2014-02-20T10:37:21Z","updated_at":"2016-01-01T23:44:54Z","closed_at":"2016-01-01T23:23:51Z","body":"Hi Igor and Others,\r\nI mostly use PostgreSQL DB and found ActiveJDBC don't know PostgreSQL's SQL dialect well.\r\nIn postgresql SQL identifiers like table name or column name should be quoted using double quote like \"Table Name\" or \"Column Name\". Example:\r\n\r\n```\r\nSELECT \"Column Name\" FROM \"Table Name\";\r\n```\r\nI recently forked this project and planned to fix PostgreSQL issues. \r\nWhen I finish I will ask You to merge my changes to your project.\r\n"},"comment":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/comments/168351016","html_url":"https://github.com/javalite/activejdbc/issues/229#issuecomment-168351016","issue_url":"https://api.github.com/repos/javalite/activejdbc/issues/229","id":168351016,"user":{"login":"kmentzelos","id":5177573,"avatar_url":"https://avatars.githubusercontent.com/u/5177573?v=3","gravatar_id":"","url":"https://api.github.com/users/kmentzelos","html_url":"https://github.com/kmentzelos","followers_url":"https://api.github.com/users/kmentzelos/followers","following_url":"https://api.github.com/users/kmentzelos/following{/other_user}","gists_url":"https://api.github.com/users/kmentzelos/gists{/gist_id}","starred_url":"https://api.github.com/users/kmentzelos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmentzelos/subscriptions","organizations_url":"https://api.github.com/users/kmentzelos/orgs","repos_url":"https://api.github.com/users/kmentzelos/repos","events_url":"https://api.github.com/users/kmentzelos/events{/privacy}","received_events_url":"https://api.github.com/users/kmentzelos/received_events","type":"User","site_admin":false},"created_at":"2016-01-01T23:44:54Z","updated_at":"2016-01-01T23:44:54Z","body":"ok, thanks."}}