[Fwd: Q: database schema from JDBC driver and netbeans.]

 Hi,

 Let me respost my email.
I removed the attachment, for I was told that it's potentially dangerous.
Any comment would be appreciated.

Thanks and regards,
Ryoji

-------- Original Message --------
Subject: Q: database schema from JDBC driver and netbeans.
Date: Thu, 05 Aug 2004 18:48:40 +0900
From: "Ryoji Sawa" <Ryoji.Sawa@Sun.COM>
Reply-To: Ryoji.Sawa@Sun.COM
To: pgsql-jdbc@postgresql.org
CC: Ryoji.Sawa@Sun.COM

 Hi,

 I'm using JDBC driver 'postgres74.214.jdbc3.jar' with Sun Java Studio
Enterprise 6 (based on netbeans 3.42).
 I'm struggling to create a database schema from a postgres
table. I can create a database schema from it, but it does not
have its primary key.
 If anyone know this issue or has any solution, please kindly share
with me. I attached the database schema created by netbeans.

The dump data is here. The table 'postalcode' has a primary key.
However, I could not create a database schema with primary key.

-------- Start ---------
--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

.. <snip> ..

--
-- TOC entry 7 (OID 17161)
-- Name: postalcode; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE postalcode (
    code character varying(7) NOT NULL,
    prefecture character varying(10),
    city character varying(20),
    town character varying(50)
);


.. <snip> ..

--
-- Data for TOC entry 11 (OID 17161)
-- Name: postalcode; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 8 (OID 17163)
-- Name: postalcode_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY postalcode
    ADD CONSTRAINT postalcode_pkey PRIMARY KEY (code);

.. <snip> ..
-------- End ---------




Thanks and regards,
Ryoji