There is a menu item under Display called System
Objects. Enable this, restart PgAdmin. Then when you connect youll
have all schemas/objects listed.
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of adey
Sent: 07 July 2006 1:26 am
To: pgsql-admin@postgresql.org;
postgresql-l; [EMAIL PROTECTED]
Subject: [ADMIN] PGAdmin
Jobs
Please assist me in implementing this for the first time?
I have installed Postgres 8.1.4 on my laptop, including Admin, then
accessed the database postgres from PGAdmin 1.4.2 and run the
pgagent.sql script tp populate the database with the following
result:-
NOTICE:
CREATE TABLE / PRIMARY KEY will create implicit index
pga_jobagent_pkey for table pga_jobagent
NOTICE: CREATE TABLE will create implicit sequence
pga_jobclass_jclid_seq for serial column
pga_jobclass.jclid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_jobclass_pkey for table pga_jobclass
NOTICE: CREATE TABLE will create implicit sequence
pga_job_jobid_seq for serial column pga_job.jobid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_job_pkey for table pga_job
NOTICE: CREATE TABLE will create implicit sequence
pga_jobstep_jstid_seq for serial column
pga_jobstep.jstid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_jobstep_pkey for table pga_jobstep
NOTICE: CREATE TABLE will create implicit sequence
pga_schedule_jscid_seq for serial column
pga_schedule.jscid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_schedule_pkey for table pga_schedule
NOTICE: CREATE TABLE will create implicit sequence
pga_exception_jexid_seq for serial column
pga_exception.jexid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_exception_pkey for table pga_exception
NOTICE: CREATE TABLE will create implicit sequence
pga_joblog_jlgid_seq for serial column pga_joblog.jlgid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_joblog_pkey for table pga_joblog
NOTICE: CREATE TABLE will create implicit sequence
pga_jobsteplog_jslid_seq for serial column
pga_jobsteplog.jslid
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pga_jobsteplog_pkey for table pga_jobsteplog
Query
returned successfully with no result in 1407 ms.
...but
these objects don't appear in PGAdmin under the postgres database. If I rerun
all or part of this script, it says the object already exists, and I can see
the objects through psql from the command line, eg: select * from
pgagent.pga_jobstep.
How do I
get these objects to appear in PGAdmin please, and how do I get the schema
Information Schema to appear too?
!DSPAM:14,44adaa6934531998619277!
