phppgadmin

Use for the phppgadmin Reports Database?

phppgadmin comes with instructions for creating a reports database on the system for use with phppgadmin. The instructions describe how to set it up, but do not really give any indication of what its purpose is, and the phppgadmin site was not very helpful either. It seems to allow you to store SQL queries, so is it for storing admin qu...

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin? ...

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 other users" error. I've read that one possibility is getting the pids of the processes i...

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 tablename... I want to use Pgadmin to to import this file using execute SQL command. ...

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 ? ...

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

Hey everyone, 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 end. The problem is that the important ones on the right are way of the scr...

PhpPgAdmin Syntax error when creating View

I am attempting to create a View in PhpPgAdmin (PostGreSQL db) which has the following SQL statement: DELETE FROM myTable WHERE myTable.error IS NULL; PhpPgAdmin gives me the following error: ERROR: syntax error at or near "DELETE" at character 59 In statement: CREATE OR REPLACE VIEW "Schema1"."Delete empty errors" AS DELETE ...

How to import a CSV?

I've got a CSV file that looks like this: id, name 0, A.D. TRAMONTANA 1, Abarth 2, Abbot-Detroit 3, AC ... I'm trying to import it into my table via phpPgAdmin. It gives me this error: SQL error: ERROR: column "id, name" of relation "app_vehiclemake" does not exist LINE 1: INSERT INTO "public"."app_vehiclemake" ("id, name") VALUES...

Access phppgadmin from another computer?

I have installed phppgadmin in a Ubuntu server and want to access it from another computer. It said access denied when i typed: http://<ip>/phppgadmin The port 5432 is opened in the Ubuntu server but just for local ip. Thanks ...

Can I use PostgreSQL 8.3.x for OpenStreetMap?

Hi! I'm trying to install phpPgAdmin as an XAMPP addon when I encountered an error because the latest phpPgAdmin supports upto PostgreSQL version 8.3.x. So I decided to install PostgreSQL 8.3.11 instead of the latest (PGSQL 8.4.x). Will this matter to my OSM application? Thanks! ...

Querying a self relationship category table

I am trying to optimize my php code for the following table Create table categories ( cat_id Int UNSIGNED NOT NULL AUTO_INCREMENT, parent_id Int UNSIGNED, cat_name Varchar(50) NOT NULL, Primary Key (cat_id)) ENGINE = InnoDB; To get all categories and subcategories i use one query for querying only parent categories and th...