{"action":"created","issue":{"url":"https://api.github.com/repos/geops/mdb-pgsql/issues/1","labels_url":"https://api.github.com/repos/geops/mdb-pgsql/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/geops/mdb-pgsql/issues/1/comments","events_url":"https://api.github.com/repos/geops/mdb-pgsql/issues/1/events","html_url":"https://github.com/geops/mdb-pgsql/issues/1","id":88176399,"number":1,"title":"No .sql file after executing","user":{"login":"edips","id":3856713,"avatar_url":"https://avatars.githubusercontent.com/u/3856713?v=3","gravatar_id":"","url":"https://api.github.com/users/edips","html_url":"https://github.com/edips","followers_url":"https://api.github.com/users/edips/followers","following_url":"https://api.github.com/users/edips/following{/other_user}","gists_url":"https://api.github.com/users/edips/gists{/gist_id}","starred_url":"https://api.github.com/users/edips/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edips/subscriptions","organizations_url":"https://api.github.com/users/edips/orgs","repos_url":"https://api.github.com/users/edips/repos","events_url":"https://api.github.com/users/edips/events{/privacy}","received_events_url":"https://api.github.com/users/edips/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-14T12:19:14Z","updated_at":"2015-06-17T21:38:15Z","closed_at":null,"body":"It works and process all mdb tables on terminal however there is no .sql file even I set to TMPDIR=/home/user dictionary.\r\nits output:\r\nroot@edips:/home/edip/Desktop/SQL/deneme/sql# ./mdb-pgsql.sh test-database.mdb\r\nbegin;\r\nset search_path to public;\r\nset standard_conforming_strings=on;\r\ncreate or replace function sqlite3_datetime(bigint) returns timestamp without time zone as $$\r\nselect (TIMESTAMP WITH TIME ZONE 'epoch ' + $1/1000 * INTERVAL '1 second')::timestamp without time zone;\r\n$$ language sql;\r\ncreate or replace function sqlite3_datetime(integer) returns timestamp without time zone as $$\r\nselect (TIMESTAMP WITH TIME ZONE 'epoch ' + $1/1000 * INTERVAL '1 second')::timestamp without time zone;\r\n$$ language sql;\r\n\r\n\r\nCREATE CAST (bigint AS timestamp without time zone) WITH FUNCTION sqlite3_datetime(bigint) AS ASSIGNMENT;\r\nCREATE CAST (integer AS timestamp without time zone) WITH FUNCTION sqlite3_datetime(integer) AS ASSIGNMENT;\r\ncreate table public.\"economics\" (\"id\" integer, \"month qty\" double precision, \"unit price\" text, \"tr (in mil)\" text);\r\ncreate table public.\"closeouts\" (\"qty\" text, \"whl sale\" text, \"savings\" text, \"price\" text);\r\nINSERT INTO public.\"economics\" VALUES(1,1.0,'56.6550','56.6550');\r\nINSERT INTO public.\"economics\" VALUES(2,2.0,'54.1800','108.3600');\r\nINSERT INTO public.\"economics\" VALUES(3,3.0,'51.7050','155.1150');\r\nINSERT INTO public.\"economics\" VALUES(4,4.0,'49.2300','196.9200');\r\nINSERT INTO public.\"economics\" VALUES(5,5.0,'46.7550','233.7750');\r\nINSERT INTO public.\"closeouts\" VALUES('2','12.6','10%','11.34');\r\nINSERT INTO public.\"closeouts\" VALUES('2','12.6','10%','11.34');\r\nINSERT INTO public.\"closeouts\" VALUES('2','12.6','10%','11.34');\r\nINSERT INTO public.\"closeouts\" VALUES('2','37.5','5%','35.63');\r\nINSERT INTO public.\"closeouts\" VALUES('4','32.25','5%','30.64');\r\nDROP CAST (bigint AS timestamp without time zone) CASCADE;\r\nDROP CAST (integer AS timestamp without time zone) CASCADE;\r\ndrop function if exists sqlite3_datetime(bigint);\r\ndrop function if exists sqlite3_datetime(integer);\r\n\r\ncommit;"},"comment":{"url":"https://api.github.com/repos/geops/mdb-pgsql/issues/comments/112958253","html_url":"https://github.com/geops/mdb-pgsql/issues/1#issuecomment-112958253","issue_url":"https://api.github.com/repos/geops/mdb-pgsql/issues/1","id":112958253,"user":{"login":"edips","id":3856713,"avatar_url":"https://avatars.githubusercontent.com/u/3856713?v=3","gravatar_id":"","url":"https://api.github.com/users/edips","html_url":"https://github.com/edips","followers_url":"https://api.github.com/users/edips/followers","following_url":"https://api.github.com/users/edips/following{/other_user}","gists_url":"https://api.github.com/users/edips/gists{/gist_id}","starred_url":"https://api.github.com/users/edips/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edips/subscriptions","organizations_url":"https://api.github.com/users/edips/orgs","repos_url":"https://api.github.com/users/edips/repos","events_url":"https://api.github.com/users/edips/events{/privacy}","received_events_url":"https://api.github.com/users/edips/received_events","type":"User","site_admin":false},"created_at":"2015-06-17T21:38:15Z","updated_at":"2015-06-17T21:38:15Z","body":"Thank you. I tryed a few scripts to convert mdb to Postgresql but I couldnt succeed with mdb data with turkish characters. Fortunately only this script can work smooth with even big mdb file with Turkish characters."}}