2012年10月31日
摘要: /* * testlibpq.c * * Test the C version of libpq, the PostgreSQL frontend library. */#include <stdio.h>#include <stdlib.h>#include <libpq-fe.h>static voidexit_nicely(PGconn *conn){ PQfinish(conn); exit(1);}intmain(int argc, char **argv){ const char *conninfo; PGconn *conn; PG... 阅读全文
posted @ 2012-10-31 17:27 赖侨杰 阅读(5688) 评论(0) 推荐(0) 编辑
摘要: SELECT a.attname 字段名 ,format_type(a.atttypid, a.atttypmod) 字段类型,d.adsrc 缺省值,a.attnotnull 非空,f.description 描述FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnumLEFT JOIN pg_description f ON a.attrelid = f.objoid AND a.attnum = f.objsubid WHERE a.att... 阅读全文
posted @ 2012-10-31 17:20 赖侨杰 阅读(215) 评论(0) 推荐(0) 编辑