LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 07-12-2006, 09:37 PM   #1
ethnicme
LQ Newbie
 
Registered: Jun 2006
Posts: 8

Rep: Reputation: 0
Scripts updating a postgres database


is it possible to update a postgress sql database using a shell scripts..


how can I do these..?..
 
Old 07-15-2006, 10:21 AM   #2
MensaWater
Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,009
Blog Entries: 5

Rep: Reputation: 787Reputation: 787Reputation: 787Reputation: 787Reputation: 787Reputation: 787Reputation: 787
Anything you can do from the command line (CLI) can be done from a script. Sometimes its as simple as just creating a simple text file that contains the information you would have put on the command line.

Databases also typically have SQL (Structured Query Language) scripts that use commands unique to them (e.g. select data from table where something is something).

It is common to write shell scripts that call sql scripts.

I've not worked with Postgres but did find the following thread that may give you some help. (It also leads you to the site that is designed for Postgres users that may offer you more help):

http://archives.postgresql.org/pgsql...6/msg00010.php
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
create table in postgres database kranti Linux - Newbie 1 11-15-2005 06:52 PM
Problem with Postgres Database Connection anjani.78 Linux - Software 1 10-07-2005 02:06 AM
changing password for postgres database anjani.78 Linux - Software 1 07-18-2005 10:58 PM
Connecting a Postgres Database from a Java application Paulo Ges Programming 4 08-23-2003 10:08 AM
Updating the Sources Database?? fdiaz05 Linux - Software 0 02-18-2003 12:00 PM


All times are GMT -5. The time now is 01:57 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration