Questions tagged [phppgadmin]
6 questions
5
votes
1 answer
How to set bytea_output to hex?
I cannot seem to change bytea_output to hex.
I have tried this method:
ALTER DATABASE dbname SET bytea_output TO 'hex';
I have tried to edit postgresql.conf
bytea_output = 'hex'
and restarted the server.
I have tried
SET bytea_output = 'hex'
and…
user32234
1
vote
1 answer
How to use language PL/PythonU on a PostgreSQL database via phpPgAdmin?
I am used to PgAdmin III where I can simply create python functions like the following on a PostgreSQL database:
CREATE OR REPLACE FUNCTION pyHello (x integer)
RETURNS void AS $$
if x == 1:
plpy.notice("Hello World")
$$ LANGUAGE…
q9f
- 131
- 1
- 1
- 5
1
vote
1 answer
phpPgAdmin does not see databases
When I go to databases in phpPgAdmin it says that there are 0 databases. Yet, if I run SELECT datname FROM pg_database it displays all databases OK. I would like to be able to 'explore' tables and databases.
sly
- 111
- 2
1
vote
0 answers
How to view phppgadmin as the application name in PostgreSQL's log files?
I am using PostgreSQL 9.2.2 (Windows) with phpPgAdmin 5.1.
I need to monitor who connects to the server, and with which application.
In the logging parameters of postgresql.conf, I use the following log line prefix:
log_line_prefix =…
Sébastien Clément
- 1,825
- 3
- 19
- 28
0
votes
1 answer
Cannot import database exported by phpPgAdmin
I have exported database with phpPgAdmin tool - format sql, structure and data.
When I try to import this sql using:
psql command \i filename.sql
After some time (file is 2GB) I get following error:
ERROR: unterminated quoted string at or near…
Kamil
- 103
- 2
-4
votes
2 answers
Auto fix the auto increment in MySQL
I have a table, and I have admin panel which can delete the records from the db, so that the ID becomes like 1, 4, 7, 9, 11, 24, etc. But am using the ID count for a chart.
The problem is that I need the table to auto fix the auto increment so that…
Ajith
- 1
- 1