Select * INTO [TEXT;CharacterSet=65001;FMT=CSV;DELIMITED;HDR=YES;DATABASE=E:\temp\].test.csv FROM tablename

另外，向Postgre中导入CSV

copy tablename(item,...) from 'e:\temp\.test.csv' with csv header quote '"';

COPY tablename [ ( column [, ...] ) ]

    FROM { 'filename' | STDIN }

    [ [ WITH ]

          [ BINARY ]

          [ OIDS ]

          [ DELIMITER [ AS ] 'delimiter' ]

          [ NULL [ AS ] 'null string' ]

          [ CSV [ HEADER ]

                [ QUOTE [ AS ] 'quote' ]

                [ ESCAPE [ AS ] 'escape' ]

                [ FORCE NOT NULL column [, ...] ]