::
Reload::This Page
Home :BareBone-PostgreSQL
Home
Our Mission
phpinfo.php
phpServer Name
compare_pgs_windows.htm
BareBone_PostgreSQL_Doc
FastCGI win Server 2008/64bit
php_fastcgi_iismanager1.htm
loading_fastcgi_win7U64.htm
fastcgi_ii8_windows8.htm
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
MYSQLI Query TOOL:import
Mysqli-Query-Object
Code:
Mysqli_Query_Object.txt
Mysqli_Query_Procedure
Mysqli_query_Tool14.txt: Procedure
Oracle: Custom Query PHP web-tool
OracleQuery_Editor.txt
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 10G
Oracle 10g : Java :: JDBC
Simple_JSP.htm
Creatingtable.htm
SQL *Plus
Oralce 11.2g SQL Developer
oracle_create_table1.htm
PostgreSQL :
create_populate_db1.htm
psql_create_table1.htm
pgsAdmin GUI
AddTables_pgsAdmin1.htm
PSQL Custom Query Tool:
psql_php_query1.htm
psql_php_query1.txt
Oracle Custom Query @manas8x:
OracleQuery_Editor.txt
MySQL Custom Query Tool
mysqli_Connect_Object1.htm
Create_mysql_emp_dbms1.htm
Mysqli_query_Tool.txt
Microsoft's ACCESS Database
Maketable_Query_1.htm
MakeTable_Query_2.htm
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
Querying DB/ Table
Creating_10G_table.htm
doc_ISQL.htm
iSQL (10G)
oracle_create_table1.htm
(11.2g)
PostgreSQL
graphical_query_builder1.htm
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
EXEC DBMS_OUTPUT
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
Oracle : DB
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
pgSQL : STABLE VOLATILE
Info Stored Procedure 1
stored function cfcal
psql_funct_param1.htm
stored procedure cfcal.txt
psql_funct_param2.htm
pgSQL/PHP
pgsql_func_stable1.htm
CreateTable1_fromTable2.htm
PostgreSQL_Functions.htm
graphical_query_builder1.htm
PK_FK_Example1.htm
pk_implicit_constraints1.htm
column_row1.htm
information_schema.tables
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
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.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
Create 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_mysqli_connect1.htm
test_mysqli_connect1.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.htm
pgsql language options
pgsql_language1.htm
pg_query_showtables.htm
pdo extenison: $db=null;
pdo_pgsql_connect1.htm
pdo_pgsql_connect1.txt
dot operation:string php
php_string1.htm
php_string1.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
MySQL Workbench
MySQl Create Procedure
CALL emp_data()
MySQL Show Tables
mysql_procedure1.htm
Show_DataBases1.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.htm
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.htm
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.htm
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.htm
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.htm
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.htm
create_table_php1.txt
Insert/Update Data::Stored Function
plsql_function_insert1.htm
plsql_php_while1.htm
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
PostgreSQL :
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
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.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 :