postgreSQL 一些基礎操作

標籤：

擷取every_check_accident表中的自增id的最大值

SELECT last_value FROM every_check_accident_id_seq;

 $list = DB::getInstance(self::DBNAME)->pg_insert_id(‘every_check_accident‘,‘id‘);

 

查看postgre的版本

select version();

$list = DB::getInstance(self::DBNAME)->ServerInfo(); ＃ 擷取資料庫版本

 

鎖行 （沒測試）

select 1 as adodbignore from $tables where $where for update

$list = DB::getInstance(self::DBNAME)->RowLock($tables,$where);

 

查詢庫中的所有表名(排除系統目錄資料表)

select table_name,‘T‘ from information_schema.tables where table_schema not in ( ‘pg_catalog‘,‘information_schema‘)
union
select table_name,‘V‘ from information_schema.views where table_schema not in ( ‘pg_catalog‘,‘information_schema‘)

$list = DB::getInstance(self::DBNAME)->MetaTables(false, false); 擷取所有表名

$list = DB::getInstance(self::DBNAME)->MetaTables(true, true); 擷取所有的視圖

 

 

postgreSQL 一些基礎操作