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
