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

faster or ..... ????

From: "dedy" <slackman(at)unika(dot)ac(dot)id>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: faster or ..... ????
Date: 2005-10-06 04:54:40
Message-ID: 20051006045440.18119.qmail@mail.unika.ac.id (view raw or flat)
Thread:
Lists: pgsql-admin
Hii all,
I eould like to asking about creating table in postgres
here is the
1> can postgres do such things like this one?
  # create table address as object(address varchar(100), post(6));
  # create table id (id integer not null primary key,
                     name char(100),address); 

now i will
compare with this one >>
# create table id (id integer not null primary key, name char(100));
# create table address (id integer not null references id,
                       address varchar(100), post(6)); 

which is most faster??? 

Thank you very much for all your kind to answer my question
and my english is so bad isn't? 

Dedy Styawan
Semarang

Responses

pgsql-admin by date

Next:From: Devrim GUNDUZDate: 2005-10-06 06:18:36
Subject: Re: RPMs for RedHat ES3.0 - installation problem
Previous:From: Alvaro HerreraDate: 2005-10-06 03:36:36
Subject: Re: create table like syntax

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