Re: default timestamp and default autoinc

On Mon, 6 Nov 2000 15:00:19 +0100, Jarmo Paavilainen wrote:

> Hi,
>
> Does pg have "default timestamp" and "default autoinc" as default values
> (used in CREATE TABLE).
>

here's an example that shows how to default a timestamp and how to use a
sequence to auto-increment a primary key column:

CREATE SEQUENCE personid_seq;
CREATE TABLE person (
person_id INT4 NOT NULL DEFAULT nextval('personid_seq'),
create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
modify_date TIMESTAMP NOT NULL,
firstname VARCHAR (128) NOT NULL,
lastname VARCHAR (128),
PRIMARY KEY (person_id));
CREATE UNIQUE INDEX personid_key
ON person(person_id);
CREATE TRIGGER trg_modtime BEFORE INSERT OR UPDATE
ON person FOR EACH ROW
EXECUTE PROCEDURE setmodtime();

the trigger updates the modify_date column, and you could use that
as an alternate way of adding a timestamp.

> And where is the PostgreSQL reference guide. Or actually/maybe how do I make
> html files of the sgml files that are included with the CVS tree (what do I
> need, jade? and where do I get it?)?
>

bash# cd $POSTGRES_SOURCE_TREE/doc
bash# gmake install

should create man pages and html files for all docs

HTH
ed