SQL 工作中常用汇总 -- c 语言

create table "public"."wjpt_conn_tmp_log" ("seq_no" SERIAL, "beap" varchar(15) default ''::character varying, "customer_id" bigint default 0, "status" varchar(15) default ''::character varying, "start_time" varchar(30) default ''::character varying, "end_time" varchar(30) default ''::character varying )WITHOUT OIDS;

copy wjpt_conn_tmp_log (beap, customer_id, status, start_time, end_time) from '/database/pg/postgresql-7.3.1/bin/tt.log' USING DELIMITERS ' ';

create table "public"."wjpt_conn_tmp_log" ("seq_no" SERIAL, "beap" varchar(15) default ''::character varying, "customer_id" bigint default 0, "status" varchar(15) default ''::character varying, "start_time" varchar(30) default ''::character varying, "end_time" varchar(30) default ''::character varying )WITHOUT OIDS;

snprintf(pSQL, sizeof(pSQL) - 1, "Begin work;Truncate customer_status;Lock table customer_status;copy customer_status from '%s';Commit work;", filename);