Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: phppgadmin

How to use language PL/PythonU on a PostgreSQL database via phpPgAdmin?

By adminPosted on March 23, 2021

Question : I am used to PgAdmin III where I can simply create python functions like the following on a […]

Cannot import database exported by phpPgAdmin

By adminPosted on March 7, 2021

Question : I have exported database with phpPgAdmin tool – format sql, structure and data. When I try to import […]

Recent Posts

  • How to get interval value between two hours in mysql?
  • Why do the MySQL bin log files still exist after a purge or flush?
  • How to remove temp tables from SQL Server?
  • Join 3 tables with where and sorting clauses
  • Strange performance of a top-N query with Postgres
  • How to get all the users on a database with SA access?
  • mysql threads running high issue for Percona Mysql 8.0.16
  • Design Tagging module in the database
  • Environment variable for two oracle_home
  • Improve the insertion rate of mongo sharded cluster
  • How to hint Remote Scan operator to estimate more than 10000 rows?
  • Understanding MAXDOP behaviour for queries going parallel
  • Disk space efficient foreign key index for insert intensive scientific database?
  • Refresh Materialized View impact on the DB
  • Workflow for SQL Server + Azure SQL development?
  • Execution Plan is NOT using INDEX, It uses Table Scan
  • Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
  • Optimizing a query which runs through all hours in a day
  • Implications of adding a trigger on production database
  • End of file reached. Error 38 in SQL. Passes verification checks

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding