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
3
votes
4 answers

INSERT INTO PostgreSQL

I have got a little problem with SQL. I'm trying to insert 2 values into my table. that's my query: INSERT INTO tableinfo (table,date) VALUES ('Sell','24 August'); But it doesnt work. I've got something like that: SQL error: ERROR: syntax near…
Dominik
  • 203
  • 1
  • 3
  • 10
3
votes
3 answers

Postgresql, phpPgAdmin in xammp

Hi I have this error while I'm trying to launch phpPgAdmin: Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option. I'm using XAMPP ver 1.7.7, Postgresql 9.2.4 64 bit, and phpPgAdmin…
miles
  • 225
  • 3
  • 10
  • 20
3
votes
2 answers

How to install and start phpPGAdmin

This may be a very silly question, but I can't figure out how to use the phpPGAdmin. I've downloaded and unzipped the .zip file from the website, but how do I install it? I'm using a Mac. I'm starting a lift project on a remote server and would…
Anko
  • 47
  • 1
  • 1
  • 5
2
votes
1 answer

Cannot edit or delete data or rows within phppgadmin

When I try to edit data in phppgadmin, no matter which table or row, I always got following notification 'No unique identifier for this row.' and nothing is changed/saved. The user I'm logged in has full privileges on the database and all tables in…
codyLine
  • 509
  • 2
  • 8
  • 26
2
votes
1 answer

Connect Microsoft Access to phppgadmin to query in PostgreSQL

My goal is to import data into Microsoft Access to create a database which I can reference from an excel dashboard for analysis. I can't find any information on how to connect access to allow me to query the database on phpPgAdmin. Any advice,…
Michael Lynch
  • 23
  • 3
2
votes
1 answer

why phppgadmin just display php code?

I following this tutorial How To Install phpPgAdmin on Debian 9 / Ubuntu 16.04 / LinuxMint 18 . but when I finish phppgadmin not display, even just show this ` /** * Main access point to the app. * * $Id: index.php,v 1.13 2007/04/18 14:08:48…
jazuli_18
  • 21
  • 6
2
votes
0 answers

How to disable 'drop' command in phpPgAdmin?

I want to disable 'drop' for tables and databases in phpPgAdmin, I don't want to create separate role to limit this rather just want to disable it in the application itself by changing some settings in config files(hopefully). Does anything similar…
Vinay
  • 7,442
  • 6
  • 25
  • 48
2
votes
2 answers

How to export a view data from Postgresql/Phppgadmin

I know how to export a table via PhpPgAdmin. Is there a way I can export a view data out of PhpPgAdmin. Thanks.
lud0h
  • 2,370
  • 6
  • 33
  • 41
2
votes
3 answers

phppgadmin 5.1 Misc has a deprecated constructor

10 minute ago I tried to connect with phppgadmin 5.1 but i found this error message on web server error log : " Misc has a deprecated constructor in /usr/share/phppgadmin/classes/Misc.php on line 8" Phppgadmin is out of work. I use php 7.0. Someone…
M.B.
  • 21
  • 1
  • 3
2
votes
0 answers

Postgres - Export error: Failed to execute pg_dumpall

i'm using PostgreSQL and i want to export my table in my database usng phppgadmin But the process does not allow me to do so and i'm getting this error Export error: Failed to execute pg_dumpall (given path in your conf/config.inc.php :…
Iam Moon
  • 685
  • 2
  • 7
  • 11
2
votes
2 answers

Any way to change Phppgadmin view order of columns without changing underlying db

Is there any way to change the order of the columns phppgadmin views when browsing tables without having to change the underlying db? I have a few columns that I want seperated by heaps of unimportant ones and then a few more important ones at the…
nick
  • 139
  • 1
  • 1
  • 8
2
votes
2 answers

PHPpgAdmin: How delete rows without using SQL

In phpMyAdmin I can delete rows without using SQL. Is there a way to do this in phpPgAdmin ?
xRobot
  • 25,579
  • 69
  • 184
  • 304
2
votes
1 answer

nginx - phppgadmin - *1 access forbidden by rule

I want to setup phppgadmin, postgresql is already - done by following this article but I have nginx, I did so far these configs: ln -s /usr/share/phppgadmin /var/www and /etc/nginx/sites-available/phppgadmin: server{ listen 85; …
doniyor
  • 36,596
  • 57
  • 175
  • 260
2
votes
0 answers

phppgadmin not found? (mac os x)

I tried installing/enabling phppgadmin on my mac following this guy's tutorial (one of the answers), and after doing it step by step it's still not working. Whenever I try to access localhost/phppgadmin it says "The requested URL /phppgadmin was…
rmettig
  • 31
  • 2
  • 8
2
votes
2 answers

Can't login in to phpPgAdmin

I have installed phpPdAdmin (5.1) using Yum on to a CentOS VPS. I have installed on the server Postgres 9.3.4 also using Yum. I am able to log in to a user account I have created using psql from terminal. However when I try and log in to phpPgAdmin…
user1044220
  • 269
  • 1
  • 7
  • 21
1 2
3
…
10 11