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 or flat)
Thread:
Lists: pgsql-jdbc
 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

Responses

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-2014 The PostgreSQL Global Development Group