title: How to get/create SQL statement from access table to put in Postgres DB
body: <p>I currently have an access database. Basically what I'm trying to do is take all of the tables from the access DB and put them in a postgres DB.</p>
  
  <p>Now I could write out an sql statement for each table, or manually create each table in postgres. But I was wondering if there is a program, or an addon for access that will help speed up the process.</p>
  
  <p>Below is the kind of sql statement I'm looking for.</p>
  
  <pre><code>CREATE TABLE public.Dept
  (
    Deptid integer NOT NULL,
    DeptName text,
    SupDeptid integer,
    CONSTRAINT Dept_pkey PRIMARY KEY (Deptid)
  )
  WITH (
    OIDS=FALSE
  );
  ALTER TABLE public.Dept
    OWNER TO postgres;
  </code></pre>
  
  <p>I've unfortunately had no luck finding anything to do something like this on google or stackoverflow.</p>
  
  <ul>
  <li>OS x64 Windows 7</li>
  <li>Postgres x64</li>
  <li>Office (access) x32</li>
  </ul>