Re: [SQL] CREATE TABLE

From: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
To: Ingrith Andrea Correa Vargas <i-correa(at)uniandes(dot)edu(dot)co>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] CREATE TABLE
Date: 1999-02-26 07:25:25
Message-ID: Pine.GS4.4.02A.9902260823530.11393-100000@netra.gdansk.sprint.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> I want to create a table with a column wich will have a DEFAULT
> user-function value.
> Can you write an example, with the right syntax?!
>
> I have been making some examples, but I always have a syntax error that I
> can't solve.
>
> Thank you in advance, and I'll be waiting for a response!

It could be something like:
create table test(
test_id int4 default nextval('test_seq'),
test_txt text
);
Regards
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------

In response to

  • CREATE TABLE at 1999-02-25 18:56:07 from Ingrith Andrea Correa Vargas

Browse pgsql-sql by date

  From Date Subject
Next Message Patrice DUMAS 1999-02-26 17:42:40 Unique Number KEY
Previous Message Clark Evans 1999-02-26 01:21:24 Schema / Database SELECT support?