strSQL = "select pg_attribute.attname,pg_attribute.atttypid,pg_class.relname from pg_attribute left JOIN pg_class on (pg_class.relfilenode=pg_attribute.attrelid) where pg_attribute.attstattarget<>0 and pg_class.relname='" & strTableName & "'"
但我在windows下用上面查看的命令查看时怎么会有错误提示呢,我用的是postgres8。0 for windows版本
2.psql 数据库名字
3.\d 表名