Hello, everyone.

I am VERY new, as in simply researching possibilities, to SQL Servers in
any shape or form.

However, I do have a question: on the PostgreSQL website (About Us >>
Advantages) it mentions:
"In addition to this our training programs are generally regarded as
being far more cost effective, manageable, and practical in the real
world than that of the leading proprietary database vendors.
"

Where's the training? I can't find any other information about this
remarkable training on their website. Can someone point me in the right
direction?

Cheers,

Amy Young
Sr. Revenue Analyst
Memphis, TN


---------------------------(end of broadcast)---------------------------
TIP 3: 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

I have a table with 10,000 rows. We have an application that parses a *.csv
file and uploads the data to the database table. The csv parser takes the
column numbers form the csv file and matches the column numbers to the field
positions in the DB table.

Now, I have to change the position of a column in the DB to match the csv
parser. I have a column in position 28 that I need to move to position 7.

Anyone know how to do that?

Thanks,
Derrick


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Amy Young wrote:
I think that is about the author of the web site, and is being removed.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Since the last survey on postgresql.org had almost 80% of those surveyed
wanting a standard worldwide PostgreSQL training course (and over 50% being
strongly yes), are there any forseeable future plans for standard
certification/training?

Bryan


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Bryan Encina wrote:
No, we don't know how to certify it reliably as a community. I have
training in Atlanta and don't have a huge number of folks, so if they
want training, they don't want mine. :-(

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Derrick Betts wrote:
You could DROP and re-CREATE the table.

CREATE TABLE tmp AS SELECT col1, col3, col2 FROM mytab;
DROP TABLE mytab;
ALTER TABLE tmp RENAME TO mytab;

_BUT_: You need to take care of special cases like UNIQUE & FOREIGN KEYs
etc., i.e. usually you need a better CREATE clause than this easy example.


HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Bret,

Thanks for voicing your opinion. I'll second it as loudly as I can.

I work for a small 5 member team in a major hospitality corporation.
Our team has a mish mash of responsibilities (help desk, tool design
through MS Excel and MS Access, and corporate reporting). We are just
pushing the limits of MS Access capabilities with the amount of data we
are getting pushed to us for our corporate reporting. The amount of
data is only going to grow and we realize we NEED to move to a SQL
server of some kind. Cost containment is a huge factor, so the
free-ware aspect of PostgresQL is extremely enticing. However, only 1
person on our team has ANY experience with SQL servers and none with
PostgreSQL. We originally started investigating MySQL, but found it to
be slower than the convoluted work around we've developed in MS Access.
Further investigation revealed that it may be due to how we had the
server set up. Then, someone suggestions PostgreSQL.

I have been reading what I can, and while I understand some of the
concepts, and I am still mostly floundering my way through "Greek". I
need a strong foundation in the basics. I had found the MySQL class and
have added that to my goals for next year. However, it will take some
strong arguments to convince my superiors to send me to training for
something that will "sort of" apply to what we are doing in the office.
So my options are: use MySQL instead or don't go to training.

In the mean time, I will investigate the "21 day" book (I have used the
series many times!) and hope the PostgreSQL community will recognize the
need for some training classes (The certifications are optional as far
as I'm concerned, though I recognize the power of certifications since I
used to teach at New Horizons Computer Training Center. I just want
someone to hold my hand and walk me through the entire process so I can
learn the lingo. Then, I can figure things out on my own). And I'll be
asking as many questions on the list server as I can.

Cheers,

Amy Young
Sr. Revenue Analyst
Memphis, TN

-----Original Message-----
From: pgsql-novice-owner (AT) postgresql (DOT) org
[mailtogsql-novice-owner (AT) postgresql (DOT) org] On Behalf Of Bret Busby
Sent: Wednesday, December 10, 2003 1:09 AM
To: pgsql-novice (AT) postgresql (DOT) org; pgsql-general (AT) postgresql (DOT) org
Subject: Re: [NOVICE] PostgreSQL Training


On Tue, 9 Dec 2003, Bryan Encina wrote:


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Hi,

Why worry? I'm sure that most of the guys in this list didn't have
dedicated PostgreSQL training (I didn't for sure).
You have lots of tutorials and (not to forget) a great documentation set
on the Postgres website.
There are also the mailing lists with people who like to help you. And
remember: in a open source community, you'll never be alone ;-)

Cheers!

Wim

Amy Young wrote:



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Yes I did that and lost all the connections to my sequences.

Tom

On 10 Dec 2003 at 13:16, Nabil Sayegh wrote:



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Bret.....

In my experience these have less to do with being proficient at a
disipline and more to do with marketing (of the individual holding the
certificate and of the application). The people here are more doers than
marketers.

That being said, PostgreSQL could sure use some more marketing.

Sounds like there is room for YOU and your wife could get involved in
setting up and administering some kind of PorstgreSQL certification
program! I have no idea if this would be feasible in the PostgreSQL
community or not, and I've read here that Red Hat is doing just that with
their dialect of the PostgreSQL server (maybe somebody else can
elaborate).

As far as books, I just know returned a book to the library, 'Learn SQL
in 14 days' or something similiar (sorry, don't remember the author)
and the concepts presented there (which includes triggers and
procedures, etc.) are transferrable to any SQL database.

There are some good PostgreSQL specific books, too (including Bruce
Momjian's). If you think there is a need for a basic starter's guide to
PostgreSQL you might put one together and offer it (for money, or
otherwise!).

You are right in that PostgreSQL could benefit from more marketing.

The world is your oyster!

brew

================================================== ========================
Strange Brew (brew (AT) theMode (DOT) com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
================================================== ========================



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend