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
0
votes
0 answers

PostgreSql with php trim function unexpected behavior

$str = trim($somestring); $sql = "UPDATE project SET name = '" . $str . "' WHERE id = $id"; When I am using this code without the trim() I can see the value in postgresql field (phpPgAdmin). But when I use trim(), then: The value in phpPgAdmin…
linderman
  • 149
  • 1
  • 9
0
votes
2 answers

Synology NAS, has File Station application a database and where can I find it?

Has Synology NAS DS212j a database for "File Station" application and where can I find it? I couldn't find it with phpMyAdmin nor phpPgAdmin. Some files created in File Station, I could find on the database of Media server in phpPgAdmin. But those…
iwannaknow
  • 1
  • 2
0
votes
1 answer

phpPgAdmin automatically creates null row during adding a column

I have a table, called "Route" (part of a production postgres database). Because of a missing column "arrival_time", I used the "Add column" function of phpPgAdmin. There, I added each important property (name, type). When I browse the column after…
dildik
  • 405
  • 6
  • 16
0
votes
0 answers

Dumping a database with half a million tables takes more than 24h

I have a database which is 160GB in size, and has about 500,000 tables. I ran a pg_dump yesterday using: pg_dump -U mps db_name -f db_name.sql The process seems to be running for more than 24 hours now, and i dont know how much time it will take to…
user3455531
  • 775
  • 1
  • 14
  • 28
0
votes
1 answer

Can see tables in phpPgAdmin but not in psql (or any other method)

I have recently installed postgres on my Mac and loaded a dump from our public website that I am trying to replicate locally. The pg_restore appeared to be successful, and I can see all my tables and user permissions in phpPgAdmin. They all look…
kevinrstone
  • 266
  • 2
  • 12
0
votes
0 answers

How to manipulate config/config.php.inc under mac 10.6.8?

I would like to change the setting of config.php.inc and incldude $conf['plugins'] = array('DBDesigner'); That is a plugin for the phpPgadmin in order to use the database designer as noted here: https://github.com/diorman/DBDesigner and this is how…
Googme
  • 914
  • 7
  • 27
0
votes
1 answer

delete a row that is created by django using PHPPgAdmin?

Using django, I added a new entry to my table. Now I want to delete it using PHPPgAdmin (postgresql), but I get No unique Identifier for this row error. What is the problem? django automatically adds an auto-incrementing primary key, so I cannot…
eagertoLearn
  • 9,772
  • 23
  • 80
  • 122
0
votes
0 answers

How can we export the data structre with seleted data in PostgreSQL?

I am working on the PostgreSQL 9.1.4, I have to export the Data structure with 1 row data. But PostgreSql have options of "Data only or Structure only or Structure and data". But my aim is to export the "Datastructre with 1 row data" . How can…
Kanchetianeel
  • 189
  • 2
  • 3
  • 15
0
votes
1 answer

How to say to postgres to ignore words if it's duplicate?

I'm trying to import words from a CSV file. some of its records are already in the table. My Query is as below: COPY words(word,definition,category) FROM '/home/username/Downloads/New1Names.csv' DELIMITER ',' CSV; Word column is unique. I…
Alireza
  • 6,497
  • 13
  • 59
  • 132
0
votes
1 answer

Account creating error in Postgresql 9.0 under Windows Server 2008 vs ArcGIS INSPRE modul

Helo, we have got some problem with Postgresql and ArcGIS INSPIRE modul. First of all, we are not experted and experienced in this problem, so sorry for the "amateur" sentences. The problem is that, when we try to create an account in pgAdminIII and…
user2882411
  • 1
0
votes
1 answer

how do i import postgresql database from a local folder or host directory

I have a .sql file on both my local computer and another one FTP to my host.. There is not tool in phppgdmin to import the file. What is the easiest to import the data? i have dedicated hosting, and puTTy terminal.
Albuquerque Web Design
  • 413
  • 7
  • 16
0
votes
1 answer

Unable to copy postgresql table in another database

I try to copy postgresql table in another database as I write in pgAdmin 3 this query $pg_dump -t pl_biz_enhanced business_catalog | psql business_catalog_enhanced here pl_biz_enhanced is the table i want to copy and business_catalog is the…
Tania Marinova
  • 1,788
  • 8
  • 39
  • 67
0
votes
1 answer

phppgadmin login failed

I've tried numerous methods on various posts and docs but I think I'm missing something... I just cannot login to phppgadmin using my browser. I even created a database from the terminal but I just can't seem to login using phppgadmin. It says login…
itsols
  • 5,406
  • 7
  • 51
  • 95
0
votes
1 answer

How to install PhpPgAdmin in AppServ?

How can i install phppgadmin in appserver on windows. I installed postgresql exe file and configures php.ini file and extracted PhpPgAdmin in www folder, but it showing php not congifured error.
Daya
  • 1,170
  • 10
  • 22
0
votes
1 answer

"Blank SQL" error with phppgadmin

Here is my problem: I export a database A_DB using "export" function of Phppgadmin. The dump file A_dump.sql includes both the database structure and data. Then I try to create another blank database B_DB, and import A_dump.sql into it. Every time I…
Hoàng Long
  • 10,746
  • 20
  • 75
  • 124
1 2 3
…
10
11