Thread: pgexplorer cannot see data in tables

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.

So did the script with those inserts report any errors?

On Dec 9, 2006, at 4:23 PM, Philippe Salama wrote:

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

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)