How to execute PlPgSql from Command line

Hello guys, please could someone answer my question? how to run a plpgsql script from the command line? is possible to run like that? i hava a set of scripts to run. for example insertion for one table, updation for another table. otherwise is there any option to save those scripts in a file and through some command can i execute from the command line? if so, what should be the extension of file & what is the command to run that file. please suggest me some solution.

Running ACT! 2008 Database on two Laptops

Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is my own (Vista) and the other is a company laptop. I can't synchronse using a network connection between the two machines because the work laptop has all manner of hidden firewalls etc. so this is not an option. I'm really pi**ed off that ACT! 2008 can only synchronise using a network connection. When I bought ACT! 2008 I was told synchronisation is really simple. Can't use the Internet sync as thi

Closing a database

Hello, Been away from PostgreSQL for a while and probably needs retraining in the basics. How do I close a database? Can't even find it in the Manual Case: testdb=# testdb=# EXIT; ERROR: syntax error at or near "EXIT" at character 1 LINE 1: EXIT; ^ testdb=# testdb=# QUIT; ERROR: syntax error at or near "QUIT" at character 1 LINE 1: QUIT; ^ testdb=# testdb=# END; WARNING: there is no transaction in progress <p>COMMIT</p> testdb=# quit works in MySQL Stuck in

Good News Mr 142.179.22.210 flood comp.databases.postgresql.general

Cox and Telus will not act unless they have a police file number so you may as well flood comp.databases.postgresql.general my home Usenet group. have a nice day.Me I am nearing about TrueCrype -- Gul, including frogs scrawny and metropolitan, counts in it, striping up to. -- Michael Yardley

Good News Mr 142.179.22.210 flood comp.databases.postgresql.general

Cox and Telus will not act unless they have a police file number so you may as well flood comp.databases.postgresql.general my home Usenet group. have a nice day.Me I am nearing about TrueCrype -- Yesterday Ali will crawl the being, and if Katya daily records it too, the researcher will argue unlike the famous league. -- Michael Yardley

array or not array?

Hi all, i'm a real noob in databasedesign, so i have some questions about it. In case i want to make a booklist with two tables and the following fields: owner_table has the fields ID, name, books book_table has the fields ID, author, title, isbn normally i would say, this is easy, just filling both tables with data and linking them together maybe like owner_table.books as a foreign key linked to book_table.isbn or book_table.ID. In this way i will have many datasets in owner_table with the same entry in 'name', depending on how much books this man (or women) has. But what

If criteria is Null then show all.

I have an .asp page that passes four variables to another .asp page by using an HTML form. A SQL query then runs against an Access database using those four variables. The variables are: "cnty", "rte", "bgn", and "nd". My current SQL statement is as follows: SQL = "SELECT * FROM Construction WHERE County='" & cnty & "' AND Route='" & rte & "' AND Begin<=" & nd & " AND Ending>=" & bgn & "" This works just fine, but I would like to add the ability to make "nd" and "bgn" Null (leave those fields blank on the HTML form), and then return all records that match the "cnty" and "rte"

Web Development Team Needed - Prefer Croatian or Eastern European based

> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3248690516_15585595 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit US Based Internet development company seeking to establish an ongoing relationship with one programming team. You must be able to develop database driven sites from scratch. Experience in as many of the following areas as possible is needed particularly PHP, ASP, Mysql, PostgreSQL & SQL Server. Flash Actionscripting an added plus. * Adobe F

.NET Questions

I have done database work with Borland C++ Builder and Paradox, and with ..NET and SQL Server and Paradox. I am considering a new projects with ..NET in either VB.NET or C# and I want to select between either MySQL or PostgreSql as the database. I want ideas on which database would be the best choice and for which reasons. I have a preconceived bias towards PostgreSQL because it has had COMMIT and ROLLBACK designed in from the start, and because it now has a native Win32 port. I would also like information in the interface between ADO.NET and either above database. I am e

Funny facts

DID YOU KNOW... IF YOU YELLED FOR 8 YEARS, 7 MONTHS AND 6 DAYS YOU WOUL HAVE PRODUCED ENOUGH SOUND ENERGY TO HEAT ONE CUP OF COFFEE. -(Hardly seems worth it.) - IF YOU FARTED CONSISTENTLY FOR 6 YEARS AND 9 MONTHS, ENOUGH GAS I PRODUCED TO CREATE THE ENERGY OF AN ATOMIC BOMB -(Now that's more like it!) - THE HUMAN HEART CREATES ENOUGH PRESSURE WHEN IT PUMPS OUT TO THE BOD TO SQUIRT BLOOD 30 FEET -(O.M.G.!) - A PIG'S ORGASM LASTS 30 MINUTES. -(In my next life, I want to be a pig.) - A COCKROACH WILL LIVE NINE DAYS WITHOUT ITS HEAD BEFORE IT STARVES T DEATH. -(Creepy.) (I'm

Postgresql Vs. Mysql -- Need advice

This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C6E0E1.41D83670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest = opinion/advise of smart folks like you about this. We are about to begin = development for a data intensive web based application and are faced = with the choice of database software. We (at least currently) are = focusing on free software. Some basic research has indicated both = Postgresql and Mysql as the be

BlackJack game secrets

Hallo! This site is about "How to Win" in 'BlackJack.' (http://www.blackjack.2surf.eu) And for fun: 'Belly Dance' (http://travel.ifastnet.com -- NikMuva ----------------------------------------------------------------------- NikMuvak's Profile: http://www.dbtalk.net/m92 View this thread: http://www.dbtalk.net/t33442

Excellent data mining tutorials

Came across this good website that hosts many nicely organized online data mining tutorials. People might find it interesting. http://datamining.eruditionhome.com/ Topics include Data Mining Introduction Classification Clustering Association rules Time series analysis etc.

Fastest Car in the World testdrive

Red Baron is back! Michael Schumacher decided to drive for one more year. 'Red Baron is back!' (http://www.f1world.biz/schumi.php) Found this news here: http://www.f1world.biz/schumi.php P.S. Wow, next season gonna be hot -- Enigma75 ----------------------------------------------------------------------- Enigma757's Profile: http://www.dbtalk.net/m89 View this thread: http://www.dbtalk.net/t33357

{Still have no online hobby?}

Yo, some useful links here: 'sunflower curtains (http://deck-builders.porapahat.com/sunflower-curtains.html) 'flower garden pictures (http://dentists-salaries.rubite.net/flower-garden-pictures.html) 'home builders lexington sc (http://broomlaid-flower.sotdiha.com/home-builders-lexington-sc.html) 'flowering maple (http://flower-films.zamesto.net/flowering-maple.html) 'flower mats' (h ttp://opium-flower.nemnoga.org/flower-mats.html -- ponteron ----------------------------------------------------------------------- ponterone's Profile: http://www.dbtalk.net/m89 View this thread

Tickets

Did you know that strength training is crucial for successfully losin weight and keeping it off?It doesn't have to be a huge, hulking workou where you're trying to look like Arnold Schwarzenegger in his prime, it just has to be some basic strengt training. Diet adviser <a href="http://tetra.awardspace.com">Diet pill</a> <a href="http://terra23.awardspace.com">cheap diet pill</a> Most diet drugs companies are trying to invent genuine solutions to th problems of overweight and obesity -- tetraterre2 ----------------------------------------------------------------------- tetra

BMI is calculated by taking the patient's weight

taken at the pharmacy The AHA is a not-for-profit association of health 'klonopin (http://klonopin-rx.t35.com/) care provider organizations that ar committed to health improvement in their communities. The AHA is th national advocate for its members, which include almost 5,00 hospitals, health 'nexium' (http://nexium-rx.t35.com/) care systems networks and other providers of care. Founded in 1898, AHA provide education for health care leaders and is a source of information o health care issues and trends. G'nigh -- hreftra2 ------------------------------------------------------

Carpet cleaner?

Hey do you know any good 'carpet' (http://carpet.bapki.com) cleaner i vancouver , or steam cleaning company in vancouver. can you recomen anyone. thank -- carpet-bapk ----------------------------------------------------------------------- carpet-bapki's Profile: http://www.dbtalk.net/m81 View this thread: http://www.dbtalk.net/t33120

Thank you very much for such a good work

Hi people! Very many thanks for a good work on this forum. It is Tru :-) Have a nice Day. '_' (http://phentermine.pr.nu)'_' (http://buy-cialis.ar.gs)'_ (http://buy-soma.ar.gs)'_' (http://buy-tramadol.ar.gs)'_ (http://asian-ass.esp.cc)'_ (http://phenterminetenuate.blogspot.com)'_ (http://discounttenuate.blogspot.com)'_ (http://phentermine-tenuate.blogspot.com)'_ (http://adipextenuate.blogspot.com)'_ (http://tenuatedospan.blogspot.com)'_ (http://xanaxbar.blogspot.com)'_ (http://pictureofxanax.blogspot.com)'_ (http://xanaxwithdrawal.blogspot.com)'_ (http://xanaxmedication.blogspot

The winning ways of 'Warcraft' !!!

AUSTIN, Texas--If there was one piece of noteworthy news that came ou of the first day of the annual Austin Game Conference here Wednesday it was that "World of Warcraft" publisher Blizzard Entertainmen provided keynote entertainment. ________________ 'Sports Book' (http://searchvia.net/search.php?q=Sports+Book -- Kreolinn ----------------------------------------------------------------------- Kreolinnn's Profile: http://www.dbtalk.net/m79 View this thread: http://www.dbtalk.net/t33080

Have you heared about it?

Try 'www.myspace.com' (http://stuff.bestdream.info/www.myspace.com.html or 'circuit city' (http://stuff.bestdream.info/circuit-city.html) and < href=http://stuff.bestdream.info /nudism.html>nudism</a> with < href=http://stuff.bestdream.info/short-haircut.html>short haircut</a> Mrs Most -- SentimenalMan1 ----------------------------------------------------------------------- SentimenalMan12's Profile: http://www.dbtalk.net/m79 View this thread: http://www.dbtalk.net/t33063

What do YOU think about it

What do you think about to get married? Do u want to make yourself happy??? Just one kkLick and you r in LooK 'WEDDING' (HTTP://WEDDINGBRIDAL.BRAVEHOST.COM Don't forget to went here *'Wedding Dress' (http://wedding-dress-best.50webs.com/) -- bridal200 ----------------------------------------------------------------------- bridal2006's Profile: http://www.dbtalk.net/m76 View this thread: http://www.dbtalk.net/t32955

hard fisting

'fisting movie' (http://allsupergirls.info/vfisters/fisting-movie.html) 'man fisting' (http://allsupergirls.info/vfisters/man-fisting.html) 'fisting xxx' (http://allsupergirls.info/vfisters/fisting-xxx.html) 'free fisting mpeg (http://allsupergirls.info/vfisters/free-fisting-mpeg.html) 'bbw fisting' (http://allsupergirls.info/vfisters/bbw-fisting.html) 'fist fuck' (http://allsupergirls.info/vfisters/fist-fuck.html) 'monkey fist knot (http://allsupergirls.info/vfisters/monkey-fist-knot.html) 'fist time' (http://allsupergirls.info/vfisters/fist-ti

pharmacy search

Hi people!We just opened our cool site same like this 'cat (http://www.searchsuperhit.com/catalog.html) 'cat a (http://www.searchsuperhit.com/adipex/catalog.html)'cat b (http://www.searchsuperhit.com/business/catalog.html)'cat c (http://www.searchsuperhit.com/cialis/catalog.html) 'cat d (http://www.searchsuperhit.com/dating/catalog.html)'cat h (http://www.searchsuperhit.com/hydrocodone/catalog.html) 'cat i (http://www.searchsuperhit.com/insurance/ catalog.html)'cat l (http://www.searchsuperhit.com/levitra/catalog.html) 'cat p (http://www.searchsuperhit.com/pharmacy/catalog.html)'ca

I better die

Aloha, There is a bad story that was happened to me last 2 weeks, so i want to tell everybody about this. Im working at the Security Research Group (not from Mircrosoft), we are analysing risks of bying items on the internet for the end user. So as usual, i was ordering products from my research table, the name of report were 'tickets online', so as you already understood it was all about ticketing. I chose my first item, it was about concert tickets (We usually have sitelists from our database we need to check, but this day i was thinking to try search engines for that and