pgAdmin is a graphical administration and development tool for PostgreSQL.

learn more… | top users | synonyms

1
vote
2answers
49 views

pgAdmin ||| paging?

I'm wondering if there is no paging feature for the pgAdmin III 1.22.1 Query tool. So if I try to query a table with 500k+ rows without constraints, the query takes like 30s. Is there a paging ...
1
vote
0answers
14 views

Add Shapefile loader plugin to PgAdminPortable

I'm using PgAdminPortable and I'd like to enable « PostGIS Shapefile and DBF loader » plugin. The issue is that the files are not structured as in a PostgreSQL complete install (see below). I have ...
0
votes
1answer
16 views

Amount of time FULL VACUUM/VACUUM

I have a table "lng_grid_test", which, at the beginning, had around 600 000 000 around. The table is defined as : -- Table: public.lng_grid_test -- DROP TABLE public.lng_grid_test; CREATE TABLE ...
0
votes
1answer
36 views

Database in postgresql with missing rows, how to fill the missing rows with a backup copy?

I have a big problem and I'm not that good with postgresql since I use Django to make queries and I only have the basics of sql for querys. My problem is that there was a problem where a super user ...
0
votes
1answer
22 views

Create pgAdmin database on local machine

I am trying to create databases on my local machine using pgAdmin. When I try to connect to a new server using the "New server registration" entry below it gives me the "Server doesn't listen" error (...
0
votes
1answer
31 views

pgAdmin crashes or freezes when big MATERIALIZED VIEWs are refreshing

I'm using pgAdmin III v1.22.1 on Windows 7 to connect to a PostgreSQL server version 9.4.8 on Red Hat. We have scripts to REFRESH MATERIALIZED VIEWS during the night. When they are refreshing, I can'...
1
vote
0answers
32 views

Why is Server Configuration in Pgadmin3 inaccessible for me?

My Postgres server is running (localhost:5432), but Tools > Server Configuration is greyed out for me as below. I was attempting to access it to edit/locate my postgres.conf file.
0
votes
2answers
49 views

CASE with max()

I know how to do this in SQL Server but Postgres is different. I want to return the max employee pay. Select b.enumber, b.bday, case when Max(c.id) then c.pay ELSE c.pay End As "Current Pay" From ...
1
vote
2answers
21 views

How to restore postgres database which is created using pg_dumpall?

I have dumped all of my databases using pg_dumpall and now I want to restore them. I used the command psql -f db.out postgres, but I am still not able to see my databases. Can anyone help?
1
vote
1answer
20 views

PostgreSQL, display role members

Is there a way to visualize which users are mebers of a role in PostgreSQL / pgAdminIII, like role: council_stuff members: Harry Ben Steve Melinda
1
vote
1answer
22 views

Is it possible to tell when databases, schemas and tables were created in Postgres?

Is it possible to tell when databases, schemas and tables were created in Postgres? I've serached through PgAdmin and tried the command line interface with no joy. Also can't find any reference to ...
0
votes
0answers
9 views

Jump to a given line number in pgAdmin III

I wonder whether there is any way to jump to a given line number in the "edit data" window in pgAdmin III. I am aware that I can use the sort/filter window to add filters, but I just want to jump.
0
votes
0answers
19 views

Saving the “view data options” in the “edit data” window in pgAdmin III

I wonder whether there is any way to save the "view data options" in the "edit data" window in pgAdmin III: It's annoying to have to input them again each time one opens a new "edit data" ...
1
vote
0answers
15 views

I cannot switch back to pgAdmin III's Database Designer's default font

I changed the default pgAdmin III's Database Designer's default font, which used to be MS Shell Dlg 2: I cannot set it back to the default font, namely MS Shell Dlg 2. Why? I don't see MS Shell ...
1
vote
0answers
16 views

How can I change the font in the “edit data” window in pgAdmin III?

I wonder whether I can change the font in the "edit data" window in pgAdmin III. Use case: I want to have the text of a column in two subsequent rows to be aligned by character: to do so, I'd like ...
0
votes
1answer
25 views

How can I edit the content of a table in the data output of a query in pgAdmin III?

I wonder whether I can edit the content of table in the data output of a query in pgAdmin III? The query is a select * from [...]. MySQL Workbench allows users to edit the content of table in the data ...
0
votes
1answer
24 views

How can I clear output of a query in pgAdmin III?

I wonder whether I can clear the output of a query in pgAdmin III (aside from running another query).
0
votes
2answers
214 views

pgAdmin 9.5 not showing all databases

I have a problem with my database. I installed PostgreSQL 9.5 on my Ubuntu server. I changed the postgresql.conf file to allow binding the PostgreSQL server to the localhost. This allows me to run ...
0
votes
0answers
15 views

pgadmin III backup screen freeze

I wanted to get a backup for a very large database with pgAdmin, I started as usual backups, but after a couple of hours it still runs, and I can't cancel it also. I don't even get to see the file ...
0
votes
0answers
27 views

search pgadmin for column

I'm a front end dev and this is my first time doing serious database work. I have json sent to the client that looks like this: prop[0].event.history = 'foo'; //can also be 'bar' I wanted to ...
0
votes
0answers
42 views

Why default db privilleges are not applied on a new schema?

I have a user with all privileges granted by default in database properties. I create a new schema as postgres and table there. I expect that the user should have an access to this table but it looks ...
0
votes
1answer
53 views

Why can I drop table when logged in as not owner?

I read that only owner can drop table and no other user may be granted to do so. I created a table with owner postgres and then drop it as another user. What privileges should I revoke to disallow it?...
4
votes
1answer
116 views

pgAdmin is extremely slow on any remote operation

I run this query from my local pgAdmin connecting remotely to our dev server: select * from users order by random() limit 1; it hangs for 17 seconds and shows Total query runtime: 148 ms. 1 row ...
1
vote
1answer
56 views

is there a GUI client that can execute multiple queries and show its multiple results? [closed]

I'm currently using pgadmin and it appears that it is not possible to send more than one query and retrieve multiple data sets back. For example, if I try to do this: select travelerId, name from ...
1
vote
1answer
95 views

Is it possible to view a SQL query in the PgAdmin III Graphical Query Builder?

I often use pgadmin III's graphical query builder to design my SQL queries. I can then toggle back to the SQL Editor tab, and grab the SQL. Is it possible to paste a SQL query in to the SQL Editor ...
1
vote
0answers
71 views

Improve lookup of 1.5 million rows

I have this table with data but we need to get all the (unique) rdx and rdy values: CREATE TABLE public.positions ( datetime timestamp without time zone NOT NULL, unitid bigint NOT NULL, rdx ...
0
votes
1answer
41 views

Connecting existing Postrgres database with pgadmin

I have a pg database and recently I have installed pgadmin3 to view the table and data in it. After installing pgadin3, I am confused how to display my existing pg database in pgadmin3. How to link my ...
0
votes
1answer
81 views

pgAgent doesn't run on another database than “postgres”

I run a postgreSQL 9.3.3 database and I want to do some automatic Tasks with pgAgent, but it doesn't run on another database than "postgres" db. What can I do to run pgAgent on another db ? thanks !
0
votes
1answer
254 views

How do I load a data-only dump created with pg_dump to another database?

I have two PostgreSQL databases on my development server, one I use for development and another for production where I test my web applications. When I was using an earlier version of PostgreSQL I was ...
0
votes
1answer
401 views

See entire string from a lengthy text field in pgAdmin?

Using pgAdmin, how can I see the entire string value for a row when the value is very long? For example, the value may be comma-separated values (CSV) content with hundreds or thousands of ...
0
votes
1answer
18 views

Returning results from many functions / statements

I have a function that I will be running 10-50 times at once: importsitechanges(33, 209703, 'Store Name', 'Addr', 'city', 'state', 'zip', 'phone') This function that I made returns the number of ...
0
votes
1answer
236 views

Keyboard shortcut to execute statement at cursor in pgAdmin

In MySQL Workbench, one can use the keyboard shortcut Ctrl + ENTER to execute the statement at cursor (delineated with semi colons). Is there a similar shortcut in pgAdmin?
1
vote
1answer
69 views

Checking whether my pgAdmin III is a 32 or 64 bits version

I need to check if my pgAdmin III is a 32 or 64 bits version. Where can I find this information? The About... menu in pgAdmin GUI does not mention it (only the version number like 1.20). I've looked ...
1
vote
1answer
187 views

Where can I see the exact row count of a table in pgAdmin III?

Where can I see the exact row count of a table in pgAdmin III? I know where to find the approximate row count: I am also aware I can SELECT COUNT(*) FROM my_table. But I want to know whether the ...
4
votes
1answer
92 views

DISTINCT ON vs ROW_NUMBER() for getting a row with a maximum value of a group

I have the following table in PostgreSQL 9.4: CREATE TABLE dpa( id serial NOT NULL, currency_id integer, amount numeric(14,3), date timestamp without time zone, plat_id integer, pl_id ...
1
vote
0answers
278 views

PgAgent unable to run a job

I am running PostgreSQL 9.4.5 on Ubuntu 14.04.3. I am trying to set up pgAgent job but I keep getting this error: DEBUG: Creating DB connection: user=xxx host=localhost port=5432 dbname=otherdb ...
0
votes
0answers
66 views

How to disable switch user option in PgAdmin

I have created read only user with following command (executed from postgres user) create user read_user with password 'read_pwd'; revoke all privileges on database db1 from public; revoke all ...
2
votes
2answers
1k views

PostgreSQL “size of temporary files”

I've imported data into a new database (about 600m rows of timestamp, integer, double). I then created some indexes and tried to alter some columns (got some out of space issues), the database is ...
1
vote
0answers
90 views

pgAdmin export line overflow on large field

Background: I have a database of significant geographical locations downloaded from GeoNames open database. The create script for the table is as follows CREATE TABLE populargeonameswiki ( geonameid ...
1
vote
1answer
290 views

PostgreSQL - pgAdmin - path to database

I am new to PostgreSQL and I can not found info about this. I am using pgAdmin III and my databse files are kept in instalation directory of PostgreSQL. So far so good. But now, I need to create huge ...
4
votes
1answer
1k views

RETURN TABLE is converted to RETURN SETOF int in Postgres function

In pgAdminIII I create a function that returns multiple rows in a single column named identifier using RETURN TABLE: CREATE OR REPLACE FUNCTION test( IN parm1 date, IN parm2 interval) ...
1
vote
0answers
37 views

Will pgAdmin III let me run an SQL command that works after detaching from my SSH tunnel?

I just discovered pgAdmin III and I am absolutely overwhelmed by the number of options it offers. I'd like to try to replace my traditional workflow (psql ran over an SSH session) with this tool. The ...
0
votes
1answer
402 views

How to execute two transactions concurrently in PostgreSQL?

I want to execute two transactions concurrently in pgAdmin: --The first transaction should modify the age of Paul BEGIN; DECLARE newage INTEGER; --the original age of Paul is 32 newage := Select age ...
3
votes
2answers
4k views

Error 42P01: relation does not exist

I'm new at creating databases, and this error has me dumbfounded, as I am super new with DB admin things (I mostly do reporting type queries). I created a new database through pgAdmin3 GUI, and I'm ...
0
votes
2answers
1k views

pgAgent : how to configure pgpass.conf for a local connection on Windows Server 2008

I try to configure pgAgent on Windows server 2008 to make automatic backup on the database. pgAgent is installed on the server and the service is running normally. I use PgAdmin3 and PostgreSql 9.3 I ...
2
votes
1answer
4k views

Is there a timeout option for remote access to PostgreSQL database?

I'm working via pgAdmin III on a remote PostgreSQL database. After a not so long period (say 10-15 min.) without doing anything in pgAdmin, the connection automatically expires. I therefore have a ...
1
vote
1answer
88 views

PgAdmin III - Number of lines returned during insertion

Not crucial question here, just curiosity. I am inserting data via multiple scripts in a base running in PostgreSQL. I wanted to test the time requested to end the insert, so I requested many times ...
1
vote
1answer
157 views

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: ...
1
vote
0answers
98 views

Pass a URI as a pgAdmin parameter

I can connect to Heroku with psql passing a URI: $ psql postgres://user:password@ec2-54-243-xxx-xxx.compute-1.amazonaws.com:5432/d7xkxididkdi I want to do the same with pgAdmin: $ pgadmin3 -qc ...
3
votes
0answers
194 views

XRC error when trying to access PostgreSQL view properties

I have strange problem, when trying to access PostgreSQL view properties through PgAdmin III: Error: XRC error: 197: invalid row index 1: must be less than 1 After this error is displayed, I am ...