postgresqlcolumninfosql.java

羽量级数据持久层开发框架

package org.speedframework.sql.postgresql;

import org.speedframework.sql.AbstractTableInfoSQL;
import org.speedframework.utilities.StringUtils;

/**
 * Class PostgresqlColumnInfoSql
 * 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-10-22 上午09:09:34 $
 */
public class PostgresqlColumnInfoSql extends AbstractTableInfoSQL {

	public String getSQL() {
		StringBuffer sql = new StringBuffer();
		String tableName = StringUtils.getExcuteTableName(this.tableObject
				.getClass());

		sql
				.append("select conkey,attnum,attname,typname,adsrc,relname as tablename ");
		sql
				.append("from pg_attribute inner join pg_class  on pg_attribute.attrelid = pg_class.oid ");
		sql
				.append("inner join pg_type   on pg_attribute.atttypid = pg_type.oid ");
		sql
				.append("left outer join pg_attrdef on pg_attrdef.adrelid = pg_class.oid and pg_attrdef.adnum = pg_attribute.attnum ");
		sql
				.append("left outer join pg_description on pg_description.objoid = pg_class.oid and pg_description.objsubid = pg_attribute.attnum ");
		sql
				.append("left outer join pg_constraint on pg_constraint.conrelid=pg_class.oid and pg_constraint.contype='p' ");
		sql
				.append("where  pg_attribute.attnum > 0  and attisdropped <> 't'  and pg_class.relname= '");
		sql.append(tableName);
		sql.append("' order by pg_attribute.attnum ");

		return sql.toString();
	}
}