pgexplorer cannot see data in tables
От | Philippe Salama |
---|---|
Тема | pgexplorer cannot see data in tables |
Дата | |
Msg-id | 20061209212359.78580.qmail@web90504.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: pgexplorer cannot see data in tables
|
Список | 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.
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.
В списке pgsql-admin по дате отправления: