I have recently downloaded the newest version of pgAdmin2 (1.4.2).
I connect to the server from a remote location, see all of the databases,
but see none of the tables under the database node.
The Query Wizard is the only place where I can view the tables.
Any thoughts?
Thanks,
D. Betts
-
I have the following situation:
Test database inside our network, accessed with
pgAdminIII version 1.0.2.
When I INSERT records into a
table (3000-5000 in one transaction) it takes between 2.5 - 5 seconds. No
worries there.
Production database that is hosted remotely,
accessed with
The Grant Wizard is a fantastic tool. I have a question about how to use
it...
When I open the Grant Wizard, I can only assign GROUPS to the tables,
functions, etc. The drop down box only shows groups, not specific users.
How do I assign specific users? In SQL I normally write "GRANT ALL ON
I am having the same issue with backup and restore. I have replaced the
files on my Windows xp machine that is running pgAdmin III 1.4b3 with those
dated 10-23 from the binary snapshot. The postgres version is 8.0.4 runing
on Linux.
Did I miss something else?
Thanks,
Derrick
- Original
stationid LIKE 'B01%';" This will return all the employees whose StationID
matches that of the Sr. Manager. If you only want the employees under a Manager,
just change the LIKE clause in the query to: LIKE 'B01ZZ%'
Hope this helps.
Derrick Betts
- Ori
ionID.
Hope this
helps.
Derrick
Betts
You should never design a database structure that
requires you to access a completely different database. The best way to
keep data separate, yet give your users access to the uniqueness of a separate
structure, is to create different schemas.
You may wish to spend some time re-thinking th
Jeanie Schwenk wrote:
Thank you for your post Dave. To answer your questions, the encoding
is SQL_ASCII. Here are the database and table definitions as well as
the table's contents:
CREATE DATABASE "Scrip"
WITH OWNER = postgres
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default;
Just a thought.. Are you leaving the cell (cursor being moved to a
different cell) in order to commit the change before you refresh the table?
Derrick
Olivier Bouiron wrote:
Hi.
This is one of the table that I use, and I have the problem with it too.
But as I said to Hiroshi Saito, I use the b
Using Postgres 8.2 on Linux based system.
Using PgAdmin III Beta 3 on Windows XP SP2.
I utilize the following process to login to the 8.2 database with
PgAdmin III Beta 3 from Windows XP.
Open PuTty.exe to create a secure connection to the database.
Open PgAdminIII to access the database.
10 matches
Mail list logo
