[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(dot)Sawa(at)Sun(dot)COM>
Reply-To: Ryoji(dot)Sawa(at)Sun(dot)COM
To: pgsql-jdbc(at)postgresql(dot)org
CC: Ryoji(dot)Sawa(at)Sun(dot)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