Re: Quotation marks in queries

well, you could always write a little function that would loop through
every object and then rename to lower case and replace all spaces with _
underscores. Then in your application code just rename everything
accordingly.

Once again, even if you are using M$ SQL server it would be a good idea
to avoid filenames with caps and spaces, I guess just keep that in mind
for future projects. I have converted large access databases where the
users just used whatever the heck they wanted just by renaming
everything and it did not take that long. It would be worth it in the
long run to do.

Good luck with your conversion.

Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lighting Admin for Postgresql 8.x

teknokrat wrote:

> The problem we have is that we want to migrate to postgresql from our
> current sql server db, but the problem with caps requiring quotes
> around them makes this a far from easy migration.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>