✏️ Edit: datatypes.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/modules/views/pgsql/templates/datatypes.php
Size: 1.76 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php /** * This file is a part of MyWebSQL package * * @file: modules/views/pgsql/templates/datatypes.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ // @@TODO: add support for lots of other pgsql data types $dataTypes = array( 'bigint' => array('type' => 'numeric'), 'bigserial' => array('type' => 'numeric'), 'bit' => array('type' => 'special'), 'bytea' => array('type' => 'binary'), 'boolean' => array('type' => 'special'), 'character' => array('type' => 'char'), 'character varying' => array('type' => 'char'), 'date' => array('type' => 'date'), 'datetime' => array('type' => 'date'), 'decimal' => array('type' => 'numeric'), 'double' => array('type' => 'numeric'), 'enum' => array('type' => 'char'), 'float' => array('type' => 'numeric'), 'integer' => array('type' => 'numeric'), 'interval' => array('type' => 'date'), 'longblob'=> array('type' => 'binary'), 'longtext'=> array('type' => 'text'), 'mediumblob'=> array('type' => 'binary'), 'mediumint' => array('type' => 'numeric'), 'mediumtext'=> array('type' => 'text'), 'numeric' => array('type' => 'numeric'), 'real' => array('type' => 'numeric'), 'serial' => array('type' => 'numeric'), 'set'=> array('type' => 'char'), 'smallint' => array('type' => 'numeric'), 'text'=> array('type' => 'text'), 'time' => array('type' => 'date'), 'timestamp' => array('type' => 'date'), 'tinyblob'=> array('type' => 'binary'), 'tinyint' => array('type' => 'numeric'), 'tinytext'=> array('type' => 'text'), 'uuid' => array('type' => 'special'), 'varbinary'=> array('type' => 'binary'), 'varchar'=> array('type' => 'char'), 'year' => array('type' => 'date'), ); ?>
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF