Add rows into Database table using Shell Script?

Question

How to add rows into table in the Database by Shell Script? I have following:

Postgres Database Name: dm
Table Name: Error Codes
Password of Database: ******

I want to add rows into table?

I am just starting Shell Scripting...

My code:

#!/bin/sh
DATABASE="dm"
USERNAME="postgres"
HOSTNAME="HBG"
export PGPASSWORD="postgres"

psql -h $HOSTNAME -U $USERNAME $DATABaSE << EOF
select * from Error Codes
EOF

Getting error:

psql: could not connect to server: Connection refused
    Is the server running on host "HBG" (192.168.0.241) and accepting
    TCP/IP connections on port 5432?

Nidhoegger · Accepted Answer · 2015-05-26 14:29:28Z

2

Have a look on how to use the psql command.

You can state any SQL query using this command. For example:

psql -c "SELECT * FROM foo" mydatabase myusername

Of course you can also use INSERT, UPDATE and all other SQL commands, as long as myusername has the rights to do so.

If you want to do this WITHOUT a password (but this is strongly disrecommended and unsecure) you can add this at the start of your script:

set PGPASSWORD=<password>

See here for full documentation: http://www.postgresql.org/docs/7.4/static/app-psql.html

answered May 26, 2015 at 14:29

Nidhoegger

5,3226 gold badges43 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Joseph Over a year ago

I am getting thid error:- Is the server running on host "abc" (192.168.1.241) and accepting

Nidhoegger Over a year ago

What are you trying to tell me?

Joseph Over a year ago

Plz can you see question again, I update code in it??

Nidhoegger Over a year ago

HOsTNAME -> linux is case sensitive... You use $HOSTNAME and declare $HOsTNAME. So $HOSTNAME is undefined. Also, is the server actually accepting connections that do not originate from localhost? If not -> Thats a question for ServerFault.

Nidhoegger Over a year ago

Edited previous comment

|

Collectives™ on Stack Overflow

Add rows into Database table using Shell Script?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related