pgexplorer cannot see data in tables

From: Philippe Salama <karebacnyc(at)yahoo(dot)com>
To: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: pgexplorer cannot see data in tables
Date: 2006-12-09 21:23:59
Message-ID: 20061209212359.78580.qmail@web90504.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

and yet, the script I ran clearly has inserts of data to the tables. And there was no indication that something failed when I ran the script

Here is an excerpt from the script file

ALTER TABLE format.statuscodes OWNER TO postgres;

SET search_path = define, pg_catalog;

--
-- Data for Name: absenteeism; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO absenteeism VALUES (1, 1, '2006-06-30', 'DA', 1);

--
-- Data for Name: badges; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO badges VALUES (1, 1, '2006-06-30', 'A');
INSERT INTO badges VALUES (2, 1, '2006-06-30', 'I');

--
-- Data for Name: departments; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO departments VALUES (1, 'Piping');
INSERT INTO departments VALUES (2, 'Electrical');
INSERT INTO departments VALUES (3, 'Instrumentation');
INSERT INTO departments VALUES (4, 'Process');
INSERT INTO departments VALUES (5, 'Mechanical');

--
-- Data for Name: doctors; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO doctors VALUES ('Baker');
INSERT INTO doctors VALUES ('Dow');
INSERT INTO doctors VALUES ('DOW');


---------------------------------
Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2006-12-09 21:25:38 Re: which ODBC to install
Previous Message Philippe Salama 2006-12-09 21:15:33 Re: which ODBC to install