{"action":"created","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/45","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/45/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/45/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/45/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/45","id":121374183,"number":45,"title":"Option for Query","user":{"login":"tsykes","id":10634558,"avatar_url":"https://avatars.githubusercontent.com/u/10634558?v=3","gravatar_id":"","url":"https://api.github.com/users/tsykes","html_url":"https://github.com/tsykes","followers_url":"https://api.github.com/users/tsykes/followers","following_url":"https://api.github.com/users/tsykes/following{/other_user}","gists_url":"https://api.github.com/users/tsykes/gists{/gist_id}","starred_url":"https://api.github.com/users/tsykes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsykes/subscriptions","organizations_url":"https://api.github.com/users/tsykes/orgs","repos_url":"https://api.github.com/users/tsykes/repos","events_url":"https://api.github.com/users/tsykes/events{/privacy}","received_events_url":"https://api.github.com/users/tsykes/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/laurenz/oracle_fdw/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-12-10T00:32:48Z","updated_at":"2016-01-07T12:48:40Z","closed_at":"2015-12-11T21:24:38Z","body":"Wondering if it makes sense to add an option when creating a foreign table to base it off a query. The MySQL FDW can have \r\n... OPTIONS (table 'hr.employees');\r\nor \r\n... OPTIONS (query 'SELECT * FROM overtime WHERE year = 2010;');\r\n\r\nIs this a possibility for the Oracle FDW to do this as well? "},"comment":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/comments/169654906","html_url":"https://github.com/laurenz/oracle_fdw/issues/45#issuecomment-169654906","issue_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/45","id":169654906,"user":{"login":"laurenz","id":220612,"avatar_url":"https://avatars.githubusercontent.com/u/220612?v=3","gravatar_id":"","url":"https://api.github.com/users/laurenz","html_url":"https://github.com/laurenz","followers_url":"https://api.github.com/users/laurenz/followers","following_url":"https://api.github.com/users/laurenz/following{/other_user}","gists_url":"https://api.github.com/users/laurenz/gists{/gist_id}","starred_url":"https://api.github.com/users/laurenz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurenz/subscriptions","organizations_url":"https://api.github.com/users/laurenz/orgs","repos_url":"https://api.github.com/users/laurenz/repos","events_url":"https://api.github.com/users/laurenz/events{/privacy}","received_events_url":"https://api.github.com/users/laurenz/received_events","type":"User","site_admin":false},"created_at":"2016-01-07T12:48:40Z","updated_at":"2016-01-07T12:48:40Z","body":"It is strange how often I hear from users who claim that they cannot create a view in Oracle.\r\nI guess it must be a power struggle between the Oracle DBAs and the PostgreSQL developers.\r\nI'd expect every company to have some kind of process to modify an Oracle schema..."}}