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.
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 |