couple of general questions

From: Culley Harrelson <culleyharrelson(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: couple of general questions
Date: 2001-01-19 00:29:44
Message-ID: 20010119002944.46487.qmail@web9602.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am in the process of developing my first database
with PostgreSQL and was hoping to find help with a few
questions:

1. Is it possible to use syntax like "if object
exists then drop it" before running your ddl
statements? Which system table do you hit?

2. In the documentation it says that of the character
data types text is best, over varchar(). Why is this?
What if any are the benefits of using an array data
type over, say, a child table holding all the values
of the array?

3. OK the CLUSTER statement. Say you cluster on the
last name of an employee table. When you then do an
insert into this table for someone named Smith is the
record logically written between the R's and the T's?
Just need to verify this is right :)

4. Lastly I wanted to confirm that the best way to
regularly run a piece of sql is to schedule a OS
script to handle it. Is this right?

Thanks for any help!

Culley

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul M Foster 2001-01-19 00:36:07 Re: RE: Why is there so much MySQL bashing???
Previous Message KuroiNeko 2001-01-19 00:20:13 RE: Troubles with performances