Home Our Mission phpinfo.php phpServer Name compare_pgs_windows.htm Oracle_Document_Outline1.htm FastCGI win Server 2008/64bit php_fastcgi_iismanager1.htm loading_fastcgi_win7U64.htm fastcgi_ii8_windows8.htm test.php phpinfo. php_ServerName. Resources :II PostgreSQL Custom Query Tool psql_php_query1.htm psql_php_query1.txt PSQL_Query_Tool.txt pgSQL_DDLDML_PHP_Tool.htm template1.htm MYSQLI Query TOOL:import Mysqli-Query-Object Code:Mysqli_Query_Object.txt Mysqli_Query_Procedure Mysqli_query_Tool14.txt: Procedure create_dept_emp_tables.htm (deployed) FYI Data Base :I Data Base : Know-What-How Common_KeyFeatures1.htm Oracle_PGS_Schemas1.htm pg_table_schema_pubic1.htm preface_1.htm preface_2.htm File_OR_DB/database.htm Hierarchy_RDBMS.htm preface_3.htm comparing_dbs_1.htm Aggregate_Composite_Data User Defined Object preface_4.htm DMBS/RDBMS :ER Database Intro1.htm Database_Intro2.htm Database_intro3.htm DataBase_Intro4.htm recovery_redolog1.htm Tuple :: Record (1,.., n-Tuple) SQL_Standards1.htm column_row1.htm SQL_Standards_2.htm DDL, DML,DCL and TCL SQL_Standards3.htm FYI Data Base :II Creating DB or Table oracle_create_table1.htm create_populate_db1.htm psql_create_table1.htm pgsAdmin GUI AddTables_pgsAdmin1.htm PSQL Custom Query Tool: psql_php_query1.htm psql_php_query1.php (intranet only) psql_php_query1.txt Oracle Custom Query @manas8x: test_scott_post4.php local : test_scott_post4.txt MySQL Custom Query Tool mysqli_Connect_Object1.htm Create_mysql_emp_dbms1.htm Mysqli_query_Tool.php intranet only Mysqli_query_Tool.txt FYI Data Base: III Transaction: !! comparing_dbs_1.htm native_dbms_sql1.htm Transaction_Isolation1.htm Transaction_Isolation2.htm Oracle_Savepoint_Rollback1.htm PostgreSQL: > PGSQL:SavePointRollBack Constraints : Keys PK_FK_Example1.htm db_Normalization.htm create_populate_db1.htm psql_create_table1.htm Database_Intro2.htm Creating_10G_table.htm Sequence_1.htm (Sequence) FYI Data Base: IV Creating DB or Table Creating_10G_table.htm graphical_query_builder1.htm oracle_create_table1.htm (11.2g) Microsoft SQL Server 2005/ASP.Net SQLServer_management.htm Intro_SQLserver2005.htm (remote ) Introduction1.htm (local) SQL_QueryDesigner1.htm TSQL1.htm doc_mm.LINQ3.htm (2008->) doc_mm.LINQ3b.htm doc_mm.LINQ4.htm postgres_vs_oracle1.htm postgresql_vs_oracle2.htm Data Type SQL /PSQL /Storage DataType1.htm DATATYPE_StickyNotes1.htm PLSQL_Syntaxes_DataType1.htm Data_Type2.htm compare_integer_number1.htm datatypes_Oracle_PGS_1.htm binary_float_nan1.htm datatype_char_varchar1.htm datatype_char_varchar2B.htm numeric_test1.htm varchar_to_num1.htm clob_to_varchar1.htm Oracle_PGSQL_ObjectType1.htm postgres_datatype1.htm FYI Data Base :V PL/SQL, PL/psgql plsql_overview_1.htm PLSQL_OverView_2.htm IN OUT parameters plsql_overview3.htm IN -OUT common parameter stored_programs_compared1.htm anonymous_block1.htm nested_block1.htm plsql_inout_param1.htm datatype_char_varchar1.htm datatype_char_varchar2.htm datatype_char_varchar2B.htm more coming SQL ::pgSQL I SQL_Standards1.htm pgs_standards1.htm column_row1.htm Compare:MySQL:Oracle:PGSQL mysql_oracle_postgresql1.htm more coming Stored Procedure: Function Info Stored Procedure 1 stored procedure cfcal stored procedure cfcal.txt PostgreSQL_Functions.htm graphical_query_builder1.htm PK_FK_Example1.htm pk_implicit_constraints1.htm column_row1.htm sql_table_name1.htm sql_noof_db1.htm Oracle Like:DBMS_OUTPUT postgres_vs_oracle1.htm postgresql_vs_oracle2.htm SQL Scope Explained SQL:DML:DDL SQL Intro1 PostgreSQL Scope: 1 Privileges: Explained Roles:Superuser Create_Role1.htm Create_db_tablespace1.htm pgs_security_label.htm User_Role_ConnectDB1.htm Employee DBMS PostgreSQL PGSQL_DBMS_Employee.htm scott_pgsql_employee.php scott_pgsql_employee.txt sql_drop_table1.htm get()4 Getting Started: I Installations: PostgreSQL_Functions.htm PostgreSQL:installation Installation: 1/2 Installation:2/2 PGSQL9.3-Stack-Builder Not-using=Stack-Builder pgAdminIII.exe Crate DB-pgAdminII AddTables_pgsAdmin1.htm phpPgAdmin:IIS limitation installation win 7 pro Apache. IIS installation_win7pro1.htm apache_iis_win7pro1.htm apache_iis_win7pro2.htm create_populate_db1.htm Spatial /Geometry postgis_installation1.htm MySQL: phpMyAdmin:IIS mysql56_manas8x_installation.htm test_mysql1.php test_mysql1.txt phpMyAdmin:IIS Tuneup pgSQL: PHP/Java PGSQL/Java/NetBean PGS_Coonection1.htm NetBean_JavaApp1.htm BuildReport_JavaApp1.txt NetBean_JavaApp1_code PGSQL/PHP Connection :pg_connect test_postgresql1.php test_postgresql1.txt pgsql language options pgsql_language1.htm pg_query_showtables.php pdo extenison: $db=null; pdo_pgsql_connect1.php pdo_pgsql_connect1.txt dot operation:string php dot operation:string txt pgSQL : Overview I Power of pgSQL pgSQL_Intro1.htm pgsql_language1.htm SQL_ComandList1.htm SQL_Operatons1.htm plsql_overview_1.htm PLSQL_OverView_2.htm IN OUT parameters plsql_overview3.htm IN -OUT common parameter stored_programs_compared1.htm postgres_vs_oracle1.htm Numeric_Data_Type1.htm Serial_DataType1.htm SEQUENCE_dat_seq1.htm Enum_DataType1.htm Record : Data Type PGSQL_Record1.htm PGSQL_Record2.htm pgSQL / Overview II Simple Function Returning Aggregated Text create_replace_function1.htm Returning Numeric create_replace_function2.htm stored proc stored proc mysql_procedure1.htm Schema and relname relname-table-name-schema datname,pg_database,datistemplate sql_noof_db1.htm psql_table_name1.htm Insert : Update data plsql_function_insert1 pgsql: fetch-assoc :single row pg_fetch_Assoc1.php psql_fetch_Assoc1.txt PDO :Selected functions php_pdo_driver1.htm MySQL : test_pdo_mysql1.htm test_pdo_mysql1.txt pdo_pgsql.htm pdo_pgsql.txt MySQL PDO::FETCH_NUM : pdo_fetch_mysql1.htm pdo_fetch_mysql1.txt MySQL PDO::FETCH_ASSOC pdo_Fetch_Assoc_mysql1.php pdo_Fetch_Assoc_mysql1.txt PGSQL PDO::FETCH_NUM, row $result = $stmt->fetch(PDO::FETCH_NUM); foreach($result as $key=>$val) pdo_Fetch_NUM1.htm pdo_Fetch_NUM1.txt pdo_pgsq_Fetch_Assoc1.htm pdo_pgsq_Fetch_Assoc1.txt PDO: Function OverFlow 1 (PDO::ATTR_CURSOR=> PDO::CURSOR_SCROLL)); pdo_pgsql1.htm pdo_pgsql1.txt PDO::FETCH_ORI_NEXT pdo_pgsq2.htm pdo_pgsq2.txt pdo_pgslq3.php pdo_pgsql3.txt MySQLi: Selected functions mysqli_Connect_Object1.htm mysqli_connect/close mysqli_connect/close/try/catch test_mysqli_connect1.htm test_mysqli_connect1.txt test_mysqli_connect2.php test_mysqli_connect2.txt mysqli_fetch_array MySQL CURRENT_USER() mysqli_fetch_array1.htm mysqli_fetch_array1.txt MySQL_func_ctof1.htm SQL Queries: Operators (...) SQL_Operators1.htm Dual : PostgreSQL No Dual SQL_Operators1.htm SQL_IS_TRUE1.htm SQL_wildcat_Operators.htm RDBMS prints column name by default: SQL_Multiply_Operator1.htm SQL_Addition_operator1.htm SQL_Division_Operator1.htm SQL round /manage decimal data SQL_Round_Decimals1.htm SQL_Minus_Operator1.htm SQL_NVAL1.htm SQL_AS_NVL2_ COALESCE1.htm` SQL Alias to columns SQL_Alias1.htm SQL_Alias_Column1.htm SQL_ANY_SUBQUERIES1.htm Alias Distinct, multiple table SQL_Aliases2.htm SQL_Multiple_Operators1.htm SQL_Multiple_Operators2.htm SQL_Greaterthan_operator1.htm SQL_LessThan_Operator1.htm SQL_Multiple_Operators2.htm SQL Queries: Aggregate Functions Column Specific /Logical Aggregate_Functions_Intro1.htm SQL_AND_OPERATOR1.htm SQL_OR_Operator1.htm SQL_LIMIT_OR_ROWNUM1.htm Oracle rowid \row_id1.htm row_num(), over , partition SQL_row_number_1.htm row_id1.htm SQL_Column_Average1.htm GROUP BY , AVG SQL_GroupBy1.htm SQL_COUNT_GROUPBY1.htm SQL_groupby_avg_count1.htm sql_groupby_having1.htm sql_having_orderby1.htm NOT EQUAL TO ( ! ) Operator SQL_GroupBy2.htm Having clause sql_count_having1.htm SQL_IN_Operator1.htm SQL_NOT_IN_operator1.htm SQL_NOT_IN_Operator2.htm SQL_Between_AND_Operator1 SQL_LIKE_Operator1.htm SQL_MoreAndLess_Operators1.htm SQL Queries:Aggregate Function II SQL MIN SQL MAX SQL_Max1.htm SQL_Max_Min1.htm Median : oracle only SQL_Max_Median1.htm STDDEV_MinMaxAvg1.htm MIN, MAX, STDDEV SQL_MaxMinMed_STD1.htm avg_max_min_having1.htm SQL To_Date Format SQL_MoreAnd_Operator1.htm SQL_TODATE_BETWEEN1.htm SQL_Dates_Between1.htm SQL MySQL date_format , SQL_tochar_date1.htm (as column) SQL_OR_Morethan_operator1.htm SQL_AS1.htm NOT IN < > Operator SQL_NOTIN_Operator3.htm SQL_IS_TRUE1.htm SQL_NOTNULL1.htm SQL_Round_Ceil_Floor1.htm get()4 SQL Queries:Analytical Analytical Functions : Analytical_Function_intro1.htm Var_POP1.htm First_Value1.htm Last_Value1.htm row_num(), over , partition Oracle :PostgreSQL compared Compare_Over_PartitionBy1.htm Compare_Over_PartitionBy2.htm First_Value_PartionBy1.htm LastValue_Preceeding1.htm PERCENT_RANK, WITHIN SQL_row_number_1.htm SQL_Rank1.htm SQL_Rank2.htm USING WITHIN SQL_RANK_DENSE_RANK1.htm USING OVER SQL_RANK_DENSE_RANK2.htm SQL_RANK_DENSE_RANK3.htm GROUP BY FUNCTIONS SQL_GROUPBY_ROLLUP1.htm SQL_CUBE_NOTIN_1.htm SQL_GROUPING_ROLLUP1.htm Regular Experssions Equivalent in PostgreSQL ~, like SQL_regexp_like1.htm get()2 get()3 get()4 SQL Queries: Date Formatting scope_mysql_datefunction.htm ORACLE_DAYFUNCTION_1.htm SQL_MoreAnd_Operator1.htm PGSQL AGE, MySQL DATE_DIFF SQL_TODATE_BETWEEN1.htm SQL_Dates_Between1.htm SQL MySQL date_format , SQL_tochar_date1.htm (as column) SQL_EXTRACT1.htm SQL_MONTHS_BETWEEN1.htm SQL_INTERVAL_DATE1.htm ADD_MONTHS, DATE_ADD,DATE SQL_ADD_MONTHS_DATE1.htm MONTHS_BETWEEN_DATE_PART1.htm DAY NAME SQL_TO_CHAR_DAY1.htm SQL_NEXT_DAY1.htm get()4 SQL Queries: Multiple-Tables-I Join-Tables SQL_JOINS_OVERVIEW1.htm SQL_INNER_JOIN1.htm SQL_EQUIJOINS1.htm SQL_NATURAL_JOIN1.htm SQL_INNER_JOIN_ALIAS1.htm SQL_LEFTOUTER_JOIN1.htm SQL_LEFT_RIGHT_OUTER1.htm SQL_SELF_UNION1.htm Access DB (Inner Join) MakeTable_Query_2.htm SQL Sub Queries: expression SQL_Case_Expression1.htm Subquery_compariosn_Operator1.htm SQL_ANY_SUBQUERIES1.htm SQL_ALL_SUBQUERIES1.htm SUBQUERY_INNERJOIN1.htm SUBQUERY_NATURALJOIN1.htm SQL_INNER_FULL_OUTER1.htm Partition, over, right outer join PART_RTOUTER_JOIN1.htm get()3 get()4 PHP-pgSQL Functions: DDL Scope_pgSQL_php1.htm create_table_if_notexists1.htm create_table_if_notexists1.txt sql_drop_table1.htm Create & Drop table pgSQL_DDLDML_PHP_Tool.htm pg_shadow1.htm pg_roles1.htm pg_roles1\birthdays.sql.txt test_pg_roles2.htm pg_select_query1.htm pg_fetch :row(), array, assoc pg_fetch_row1.htm pg_fetch_row1.txt pg_table_schema_pubic1.htm pg_emp_fetch_row1.htm pg_emp_fetch_row1.txt pg_fetch_array1.htm pg_fetch_array1.txt pg_fetch_array2.htm pg_fetch_array2.txt pg_num_rows pg_fetch_object1.htm pg_fetch_object1.txt pg_fetch_object2.htm pg_fetch_object2.txt pg_emp_fetch_object1.htm pg_emp_fetch_object1.txt fetch_result1.php fetch_result1.txt PHP-pgSQL Functions DDL 2: pg_emp_fetch_result1.htm pg_emp_fetch_result1.txt pg_emp_field_info1.htm pg_emp_field_info1.txt create_table_php1.htm Ran Once: create table create_table_php1.txt Ran Once create_table_php2.php create_table_php1.txt Insert/Update Data::Stored Function plsql_function_insert1.htm plsql_php_while1.php psql_php_while1.txt pgs_php_insert2.htm pgs_php_insert_upate1.htm DML: PHP Insert Data:HTML/PHP plsql_function_insert1 pgs_php_insert_upate1.htm link1 link1 PostgreSQL : PostgreSQL Scope: 1 Create emp dept bonus tables ALTER TABLE emp OWNER TO postgres; PGSQL_DBMS_Employee.htm while loop: pg_fetch_row($result) scott_pgsql_employee.htm scott_pgsql_employee.txt for loops and pg_num_rows($result) scott_pgsql_employee_2.htm pg_field_name($result, $j); pg_num_rows($result); scott_pgsql_employee_3.htm scott_pgsql_employee_3.txt pg_field_type($result, $j) pg_emp_field_info1.htm pg_emp_field_info1.txt sql_drop_table1.htm pg_emp_fetch_result1.htm pg_emp_fetch_result1.txt pg_emp_fetch_row1.htm pg_emp_fetch_row1.txt pg_emp_fetch_object1.htm pg_emp_fetch_object1.txt PostgreSQL functions :php pg_exec, pg_fetch_all() pg_fetch_all_columns() plsql_function1.htm plsql_fuction1.txt plsql_function1.php pg_user pg_user1.htm NetWork pgsql_inet1.htm PL/pgSQL:stored procedure RETURNS numeric pgAdmin_stored_proc1.htm Function :Parameters psql_funct_param1.htm psql_funct_param1.txt Returning Aggregated Text create_replace_function1.htm Return Boolean Return Numeric Oracle :PGSQL create_replace_function2.htm Function Returning Text psql_sum_proc1.htm using_psql1.htm Addition : Return Integer Return_Integer_Add1.htm Returning Record Type PGSQL_Record1.htm PGSQL_Record2.htm get()4 Stored Functions IF-ELSE control Statement return_boolean1.htm PL/pgSQL Record : Composite data: collections Collection_Arrays1.htm Record: Stored Function PGSQL_Record1.htm PGSQL_Record2.htm get()1 get()2 get()3 get()4 pgsql:cursor: triggger Stored Procedure:RefCursor FetchCursor_StoredFunction1.htm Declare_Fetch_Cursor1.htm FORWARD_BACKWARD1.htm Cursor_Fetch_MultipleTable1.htm get()3 get()4 OOP: PHP/PostgreSQL psql_funct_param2.php psql_funct_param2.txt psql_funct_param2.htm psql/HPH get()3 get()4 SQL:Transaction SavePointRollBackTransaction1.htm Oracle_Savepoint_Rollback1.htm Vacuum : PostgreSQL psql_create_table1.htm get()2 get()3 get()4 FAQ:1 get()1 PostgreSQL_for_Oracle_DBAs get()2 get()3 get()4 coming soon 2 get()1 get()2 get()3 get()4 FrontierSoft Bare Bone-PostGreSQL : Wednesday, January 21, 2015