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

2Q: Vacuuming and making queries case insensitive

From: "sdger erger" <killen(dot)nextdoor(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: 2Q: Vacuuming and making queries case insensitive
Date: 2008-01-28 01:07:24
Message-ID: deb32a990801271707j351f8307re772c32f5292c66f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am using PostgreSQL through the command line. I have written a small
application that retrieves me information from a database. I have figured
most things I need to know out. But I have two questions I hope you guys can
help me with.

Is there any command line script that can make the database run faster? Like
vacuuming or something. I'm sorry to ask what is surly a very simple
question. But everything is hard to the very inexperienced.

I also wonder if it is possible to make command line searches case
insensitive? Like when I write WHERE name='PHIL' I want it to be the same as
WHERE name='phil'.

This things would be great if they are possible.

Thanks for taking your time to read my email through!
Best Redards,
S.E.

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2008-01-28 01:11:49
Subject: Re: 2Q: Vacuuming and making queries case insensitive
Previous:From: A. KretschmerDate: 2008-01-27 09:54:25
Subject: Re: view database, tables, columns

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