{"action":"closed","issue":{"url":"https://api.github.com/repos/orbisgis/orbisgis/issues/1050","repository_url":"https://api.github.com/repos/orbisgis/orbisgis","labels_url":"https://api.github.com/repos/orbisgis/orbisgis/issues/1050/labels{/name}","comments_url":"https://api.github.com/repos/orbisgis/orbisgis/issues/1050/comments","events_url":"https://api.github.com/repos/orbisgis/orbisgis/issues/1050/events","html_url":"https://github.com/orbisgis/orbisgis/issues/1050","id":166596082,"number":1050,"title":"Retrieving table metadata","user":{"login":"ebocher","id":1820572,"avatar_url":"https://avatars.githubusercontent.com/u/1820572?v=3","gravatar_id":"","url":"https://api.github.com/users/ebocher","html_url":"https://github.com/ebocher","followers_url":"https://api.github.com/users/ebocher/followers","following_url":"https://api.github.com/users/ebocher/following{/other_user}","gists_url":"https://api.github.com/users/ebocher/gists{/gist_id}","starred_url":"https://api.github.com/users/ebocher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebocher/subscriptions","organizations_url":"https://api.github.com/users/ebocher/orgs","repos_url":"https://api.github.com/users/ebocher/repos","events_url":"https://api.github.com/users/ebocher/events{/privacy}","received_events_url":"https://api.github.com/users/ebocher/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orbisgis/orbisgis/labels/Orbistoolbox","name":"Orbistoolbox","color":"909850"},{"url":"https://api.github.com/repos/orbisgis/orbisgis/labels/Processing%20and%20analysis","name":"Processing and analysis","color":"158FC7"}],"state":"closed","locked":false,"assignee":{"login":"ebocher","id":1820572,"avatar_url":"https://avatars.githubusercontent.com/u/1820572?v=3","gravatar_id":"","url":"https://api.github.com/users/ebocher","html_url":"https://github.com/ebocher","followers_url":"https://api.github.com/users/ebocher/followers","following_url":"https://api.github.com/users/ebocher/following{/other_user}","gists_url":"https://api.github.com/users/ebocher/gists{/gist_id}","starred_url":"https://api.github.com/users/ebocher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebocher/subscriptions","organizations_url":"https://api.github.com/users/ebocher/orgs","repos_url":"https://api.github.com/users/ebocher/repos","events_url":"https://api.github.com/users/ebocher/events{/privacy}","received_events_url":"https://api.github.com/users/ebocher/received_events","type":"User","site_admin":false},"assignees":[{"login":"ebocher","id":1820572,"avatar_url":"https://avatars.githubusercontent.com/u/1820572?v=3","gravatar_id":"","url":"https://api.github.com/users/ebocher","html_url":"https://github.com/ebocher","followers_url":"https://api.github.com/users/ebocher/followers","following_url":"https://api.github.com/users/ebocher/following{/other_user}","gists_url":"https://api.github.com/users/ebocher/gists{/gist_id}","starred_url":"https://api.github.com/users/ebocher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebocher/subscriptions","organizations_url":"https://api.github.com/users/ebocher/orgs","repos_url":"https://api.github.com/users/ebocher/repos","events_url":"https://api.github.com/users/ebocher/events{/privacy}","received_events_url":"https://api.github.com/users/ebocher/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/orbisgis/orbisgis/milestones/5","html_url":"https://github.com/orbisgis/orbisgis/milestones/OrbisGIS%205.1%20Mol%C3%A8ne","labels_url":"https://api.github.com/repos/orbisgis/orbisgis/milestones/5/labels","id":885598,"number":5,"title":"OrbisGIS 5.1 Molène","description":"This version will contain important changes.\r\n\r\n- OSGI based architecture,\r\n- PostGIS and H2GIS frontal GUI (GDMS has been replaced by the H2GIS extension),\r\n- WPS 2.0 toolbox","creator":{"login":"ebocher","id":1820572,"avatar_url":"https://avatars.githubusercontent.com/u/1820572?v=3","gravatar_id":"","url":"https://api.github.com/users/ebocher","html_url":"https://github.com/ebocher","followers_url":"https://api.github.com/users/ebocher/followers","following_url":"https://api.github.com/users/ebocher/following{/other_user}","gists_url":"https://api.github.com/users/ebocher/gists{/gist_id}","starred_url":"https://api.github.com/users/ebocher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebocher/subscriptions","organizations_url":"https://api.github.com/users/ebocher/orgs","repos_url":"https://api.github.com/users/ebocher/repos","events_url":"https://api.github.com/users/ebocher/events{/privacy}","received_events_url":"https://api.github.com/users/ebocher/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":69,"state":"open","created_at":"2014-12-01T10:06:09Z","updated_at":"2016-09-05T12:06:24Z","due_on":"2016-03-15T23:00:00Z","closed_at":null},"comments":1,"created_at":"2016-07-20T14:31:45Z","updated_at":"2016-09-05T12:06:24Z","closed_at":"2016-09-05T12:06:24Z","body":"Create a WPS script to retrieve some basic informations on a table.\r\n\r\nExample with Postgres\r\n\r\n```sql\r\nSELECT\r\ncols.column_name,\r\npg_catalog.col_description(c.oid, cols.ordinal_position::int)\r\nFROM pg_catalog.pg_class c, information_schema.columns cols\r\nWHERE\r\ncols.table_name = 'usr' AND\r\ncols.table_name = c.relname \r\n```\r\n\r\nExample with H2\r\n\r\n```sql\r\nselect COLUMN_NAME , TYPE_NAME,  REMARKS\r\nfrom INFORMATION_SCHEMA.COLUMNS where table_name = 'BLOCK_INDICATORS';\r\n```\r\n\r\n@gpetit "}}
{"actor":{"display_login":"ebocher"}}