Stack Overflow
Stack Overflow

Questions tagged [phppgadmin]

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server.

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server. It handles all the basic functionality as well as some advanced features such as triggers, views and functions (stored procs)

162 questions
1
vote
1 answer

Creating procedures in phpPgadmin

I want create a procedure (for copying the values of one table(mover_location) to another table(mover_history) on updation) ,and want to call up on that on a trigger in postgresql with phppgadmin. Here is what i have tried : PROCEDURE :- …
KTM
  • 858
  • 4
  • 21
  • 43
1
vote
1 answer

How do I configure phpPgAdmin (hosted on Heroku) to only display my database?

There are hundreds of databases displayed on the Heroku Postgres (amazon hosted) shared environment. Using pgAdmin3, there is a filtering feature to remove the unneeded databases. Is there a similar configuration option for phpPgAdmin?
Nick
  • 1,194
  • 1
  • 10
  • 18
1
vote
0 answers

How do I configure phpPgAdmin (hosted on Heroku) to connect to Postgres (hosted on Heroku)

I have deployed phpPgAdmin to Heroku, to connect to a Postgres installation. The admin panel appears and the database shows up under servers properly. With what I am positive are the correct username and password I get "Login failed". I have read…
Nick
  • 1,194
  • 1
  • 10
  • 18
1
vote
1 answer

How to split the array and store into respected columns of table in Postgresql DataBase

I am inserting the array of elements {idno,age,salary} as {1,10000,30} in PostgreSQL database and I need to split and store into the respected columns of the table. How to store the split array elements in respect columns of table? First is this…
Kanchetianeel
  • 189
  • 2
  • 3
  • 15
1
vote
1 answer

phppgadmin not workig after update to mavericks

Before updating to mavericks on my mac book pro. I was using phpmyadmin and phppgadmin without problems. After upgrading to mavericks http://localhost/~burakk/phppgadmin/ gives me error: Your PHP installation does not support PostgreSQL. You need…
ratata
  • 1,129
  • 14
  • 42
1
vote
3 answers

PostgreSQL - Synax error in Update Query

Please check the query below. update product set product_price = 5 where product_price = 0 ERROR: syntax error at or near "set" at character 45 SQL error: ERROR: syntax error at or near "set" at character 45 In statement: SELECT COUNT(*) AS…
user2003356
  • 445
  • 2
  • 11
  • 24
1
vote
1 answer

Syntax error when trying to import database from two PostgreSQL databases

I'm trying to export a database from one server and put it on another using phpPgAdmin. My process is like this: select the database in server 1 and hit the export button select "data and structure and select the option in the dropdown…
1252748
  • 14,597
  • 32
  • 109
  • 229
1
vote
1 answer

loading postgis functions into a PostgreSQL 8.3.7 database using pgAdmin

I am trying to load postgis.sql files into a pgAdmin database (using psql) that has already been created so I can create a spatially enabled database. I have confirmed that the language "plpgsql" already exists, but I cannot execute the following…
Beardo
  • 65
  • 1
  • 2
  • 9
0
votes
1 answer

phppgadmin "login failed" between containers

Trying to enter the correct user and password set for the database fails with the extremely helpful error "login failed". As listed below, I have tried all of the common solutions for this issue as found around here, no dice yet. Containers are on…
Jacob Jewett
  • 349
  • 2
  • 4
  • 18
0
votes
0 answers

Why phpPgAdmin on ubuntu server shows message No objects found?

I try to run phpPgAdmin 5.1 under my remove ubuntu 18, but I see message No objects found. I uploaded phppgadmin from github and downloaded it under /var/www/html File /var/www/html/phppgadmin/conf/config.inc.php have : root@hoster-server:~#…
Petro Gromovo
  • 1,755
  • 5
  • 33
  • 91
0
votes
0 answers

Error 500 : Internal Server Error when open phpPgAdmin PostgreSQL in CPanel

I'm using PostgreSQL in CPanel and I was able access the phpPgAdmin normally and dealing with the databases through it, But now when I try to reach phpPgAdmin as normal it takes a long time and then a problem appears says: "Internal Server…
LaraDiv
  • 3
  • 2
0
votes
2 answers

phpPgAdmin , view/create tables etc from one user

I'm trying to achieve the following: I have user1 which is created. This user1 has databases user1_db1, user1_db2 , user1_db3 When I grant the owner of user1 to all the databases, I am able to do everything with them,except if I create user1_user1 ,…
include
  • 1
  • 3
0
votes
0 answers

How to update postgres db on server cpanel

My postgres database on cpanel is outdated and I need to update it to to meet up. But I am having trouble doing that. Can someone please help me out.
Chinedu Fabian
  • 71
  • 5
0
votes
0 answers

Adding new server to PhpPgAdmin

I want to write web app with PostgreSQL database that I already have. So is it even possible to add another server to PhppgAdmin? If it is how should I do it?
SzymoneQx
  • 1
0
votes
0 answers

On centOS is Impossible to access to phpPgAdmin due to pgsql not found

CWP Pro version 7 PHP 7.4 PHP built with modules pdo_pgsql and pgsql PostgreSQL version 9.2.24 PostgreSQL started from the CWP, the database created and user linked. but trying to access to link https://93.188.164.66:2031/phpPgAdmin/ (from CWP menu)…
SWeC
  • 165
  • 2
  • 15
1 2 3
…
10 11