pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas SMETS <tsmets@altern.org>
To: psql sql <pgsql-sql@postgresql.org>
Subject: Don't understand creation statement's answer
Date: Mon, 18 Dec 2000 00:32:54 +0100
Message-ID: <3A3D4D26.9302EE75@altern.org> (raw)


Hi,

In the long term I'm willing to construct a Little Java application that
runs a library. I was looking to create a few table & connect them
according to a non existing model . To create the Author table here's
what I thought doing for a table that should only contain The Name & the
Surname of the Author (once per Author).


<snip>
tsmets=> create sequence author_seq;
CREATE  

tsmets=> create table author ( 
tsmets=>     author_id numeric primary key default
nextval('author_seq'),  
tsmets=>     name char(25) not null, 
tsmets=>     surname char(25) not null
tsmets=>     );
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'author_pkey' for table 'author'
CREATE
tsmets=> \d author
                              Table "author"
 Attribute |     Type      |                   Modifier
-----------+---------------+----------------------------------------------
 author_id | numeric(30,6) | not null default
nextval('author_seq'::text)
 name      | char(25)      | not null
 surname   | char(25)      | not null
Index: author_pkey
 
tsmets=>                       
</snip>

Now the question is :
What is the meaning of the following statement in the table description
?

 Attribute |     Type      |                   Modifier
-----------+---------------+----------------------------------------------
 author_id | numeric(30,6) | not null default
nextval('author_seq'::text)

Why was my author_id changesdin a "nextval('author_seq'::text)".
There's no text here ?

That for highlighting the meaning of this ?

Thomas,



-- 
Sun Dec 17 19:42:31 CET 2000

Thomas SMETS                        e-mail : tsmets@altern.org
Av. de la Brabançonne 133 / 3       Tel. : +32 (0)2 742. 05. 94.
1030 Bruxelles
======= Quote of the Day =========
If at first you don't succeed, you must be a programmer.
========= End of Quote ===========



view thread (3+ messages)  latest in thread

Message-ID: <3A3D4D26.9302EE75@altern.org>
Permalink:  ../3A3D4D26.9302EE75@altern.org/
Also on:    postgresql.org/message-id/3A3D4D26.9302EE75@altern.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tsmets@altern.org
  Subject: Re: Don't understand creation statement's answer
  In-Reply-To: <3A3D4D26.9302EE75@altern.org>
  References: <3A3D4D26.9302EE75@altern.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox