Skip site navigation (1) Skip section navigation (2)

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

From: Ryoji Sawa <Ryoji(dot)Sawa(at)Sun(dot)COM>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Ryoji(dot)Sawa(at)Sun(dot)COM
Subject: [Fwd: Q: database schema from JDBC driver and netbeans.]
Date: 2004-08-05 10:00:13
Message-ID: 4112052D.B3192531@Sun.COM (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

 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,

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


 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;


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

    ADD CONSTRAINT postalcode_pkey PRIMARY KEY (code);

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

Thanks and regards,


pgsql-jdbc by date

Next:From: Jose.SilvaDate: 2004-08-05 10:32:44
Subject: UPDATE with JDBC fail
Previous:From: Kris JurkaDate: 2004-08-05 03:56:09
Subject: Re: Wrong column names in ResultSetMetaData

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group