Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back > Forums > Non-*NIX Forums > Programming
User Name
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.


  Search this Thread
Old 07-12-2006, 09:37 PM   #1
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
LQ Guru
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,559
Blog Entries: 14

Rep: Reputation: 964Reputation: 964Reputation: 964Reputation: 964Reputation: 964Reputation: 964Reputation: 964Reputation: 964
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):


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 12:51 AM.

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