We are mainly a SqlServer(2000) shop but would like to explore Postgresql
for possibilities.


Can you give me some comparisons between some of the different
functionalities.

Two of the main things we use with SQl.

StoredProcedures
DTS
Views


Thanks

Andy <Hoosbruin (AT) kconline (DOT) com> wrote:
Please don't say 'SQL' when you mean 'MS SQL server'.
It confuses the hell out of everybody.
See http://en.wikipedia.org/wiki/SQL

One, two, er...

No idea what you mean by 'DTS', but there's nothing lacking in
PostgreSQL's support for views and stored procedures.

It will probably not surprise you if I say that PostgreSQL is a good
database management system and will make you happy.

Ask specific questions, and I'll try to give you answers.

Yours,
Laurenz Albe

In article <JLSdnarhY9BRhpnYnZ2dnUVZ_vGdnZ2d (AT) kconline (DOT) com>, Andy wrote:
You might start from:

http://www.postgresql.org/docs/

Manuals, technical documentation, etc.

(off-topic in this group - but I've been hunting how query optimization
is implemented in different databases - especially whether there are any
extensions for user-defined functions - and I'm stuck with SQL server's
documentation, found nothing actually describing the optimizer. Have
you got any hints (and links, I need a reference)?

--

Sananvapaus on perusoikeus, ei erioikeus!
Laura Kataja
kisuli miau iki poäng fi
Kuvaelma: <http://www.helsinki.fi/~likataja/Kirjakauppa.html>

DTS ( Data Transformation Service) -- ETL (extract/translate/load)

You can take different sources( Flat-Files,Accessdb-Spreadsheet) and thru
the tool import into Sqlserver tables or export to a flat file or
spreadsheet.
It's a cool way to Transform/Transfer data.

We use this piece alot to move data in and out of SQLServer.

Does Postgresql have a anything similar ?


"Laurenz Albe" <invite (AT) spam (DOT) to.invalid> wrote

Andy <Hoosbruin (AT) kconline (DOT) com> wrote:
Thanks for the explanation.

PostgreSQL has a COPY command that allows to efficiently import and
export data from and to operating system files.
Since you are working with Microsoft programs on Windows, it will
probably be most important for you that COPY can handle all sorts of
different CSV formats.

Yours,
Laurenz Albe