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

SQL: convert backup file from copy format to insert format

I have a PostgreSQL backup made with PHPPgadmin using Export > Copy (instead Copy > SQL which is actually what I need). File contains entries like this: COPY tablename(id, field) FROM stdin; ... How to convert this file to SQL format? INSERT INTO…
takeshin
  • 49,108
  • 32
  • 120
  • 164
6
votes
1 answer

Cannot Create Table In phpPgAdmin

I'm using the PostgreSQL servers in phpPgAmin and all I want to do is create one table using SQL code. This is the code I'm using in its entirety. CREATE TABLE BIDS ( BIDID NUMERIC(3) NOT NULL, CLIENTID NUMERIC(3) NOT…
Ben
  • 1,299
  • 3
  • 17
  • 37
6
votes
2 answers

How to use phpPgAdmin with Postgres

I have installed Postgres 8.4 on Centos 6.4 64 bit by yum. I want to manage Postgres Databases with phpPgAdmin-5.0.4-1 installed by yun too (like MySQL and phpMyadmmin) After install phpPgAdmin-5.0.4-1 I cannot login to phpPgAdmin by access…
Jack Chuong
  • 63
  • 1
  • 1
  • 3
6
votes
1 answer

How to get a DataBase Design for POSTGRESQL to create a ER-Diagram?

I am using postgresql 9.2 postgres=# select version(); version ------------------------------------------------------------- PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit (1 row) and pgadmin III I have a…
09Q71AO534
  • 4,300
  • 13
  • 44
  • 68
5
votes
2 answers

phpPgAdmin - Login Fail - Virtual Class--cannot instantiate

So I followed every step of the YouTube video on getting phpPgAdmin setup with XAMPP. After I access localhost/phppgadmin using the credentials.. USERNAME: postgres password: the password I created during setup.. I click login and I get…
Sooyong Park
  • 75
  • 1
  • 3
5
votes
1 answer

Import sql dump using phppgadmin

I have phppgadmin version 5.0.4, When I click button SQL (in top-right of phppgadmin ) I must obtain window for importing sql dumps right? but in this window is only input text field for pasting sql file content Question: where is button choose…
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
4
votes
0 answers

How to increase session time for phpPgAdmin in ubuntu?

How to increase session time for postgres phpPgAdmin in Ubuntu ? After some time session get timeout.And each time I have to login.
Avinash Kadam
  • 93
  • 1
  • 4
4
votes
3 answers

PhpPgAdmin asks enter login and password

I installed PhpPgAdmin in CentOS. Every time select an object (database, table, schema,..) PhpPgAdmin asks me to enter my login and password. Left side menu (Servers->PostgreSQL) not connected. System CentOS 5 PHP Version 5.1.6…
gnabhan
  • 65
  • 1
  • 8
4
votes
0 answers

phppgadmin error "No server supplied!"

facing error "No server supplied!" while uploading file having 789.3 MB in phppgadmin. please let me know how can i resolve it. i have updated php.ini with below upload_max_filesize upload_max_filesize = 1024M
bhavika
  • 123
  • 1
  • 13
4
votes
1 answer

en_us.UTF8 collation for non-English languages

I am trying the PostgreSQL database for the first time, after having worked for some time with MySQL. My environment is a shared hosting with cPanel and phpPgAdmin. One thing that puzzles me is the database collation. My hosting's cPanel always…
texnic
  • 3,959
  • 4
  • 42
  • 75
4
votes
2 answers

phppgadmin : How does it kick users out of postgres, so it can db_drop?

I've got one Posgresql database (I'm the owner) and I'd like to drop it and re-create it from a dump. Problem is, there're a couple applications (two websites, rails and perl) that access the db regularly. So I get a "database is being accessed by…
kikito
  • 51,734
  • 32
  • 149
  • 189
4
votes
1 answer

How to login to phppgadmin

Ok, My first day with postgresql. I've downloaded and installed postgresql (to Windows), and it asked me to set a password (say: 1234). Then I downloaded phppgadmin, and trying to login to pgadmin. I tried root:1234 postgres:1234 I can't login…
ahmetunal
  • 3,930
  • 1
  • 23
  • 26
3
votes
1 answer

How to install postgresql and phppgadmin with nginx?

I need to install postgresql and phppgadmin with nginx installed under ubuntu 16(AWS) I installed packages : $ sudo apt-get -y install postgresql postgresql-contrib phppgadmin Reading package lists... Done Building dependency tree Reading…
Petro Gromovo
  • 1,755
  • 5
  • 33
  • 91
3
votes
3 answers

Postgresql "invalid end sequence"

I've a function which adds users on my application. It does a few check, salts and hashes the password and then inserts the values. Now, when i run the function I get ERROR: invalid end sequence (to be honest, i get it in italian and had to do…
frollo
  • 1,296
  • 1
  • 13
  • 29
3
votes
2 answers

Dumping of complex table and schema names on Windows is not supported. Phppgadmin. Export

I have a database named Extension A schema named public A tables named extension and mfo_3 Here's what happen. When I try to export the database from the schema not the public schema in phppgadmin, It works! But when I tried to to export within the…
Kino
  • 217
  • 1
  • 4
  • 15
1
2
3
…
10 11