Passing psql commands within shell script after connecting to AWS RDS postgres

Question

I have a shell script which I pass RDS postgres host into, within the script I can connect to postgres db via command below within script. How can I pass psql commands into the shell script to verify a table ? or list all db ? like

\dt 
\l

psql "host=$RDSHOST port=5432 sslmode=disable dbname=mydbname user=testuser password=$PASSWORD"

I get the prompt to DB no issue, would like to pass some commands to verify a db exists or list a table and exit the shell script with its output.

something similar to $ mysql -h myhost.rds.amazonaws.com -u user -D my_database -p --batch --quick -e "SELECT * FROM my_table" > output.csv — DeclanG
– DeclanG, Commented Feb 15, 2019 at 9:20
was able to get with psql -h $RDSHOST -p 5432 sslmode=disable -d mydbname -U testuser -c 'SELECT * FROM pg_catalog.pg_tables' — DeclanG
– DeclanG, Commented Feb 15, 2019 at 9:30
This works from pgadmin , SELECT * FROM pg_catalog.pg_tables WHERE schemaname = 'myschema' \ but I cannot get to run from cli, returns empty — DeclanG
– DeclanG, Commented Feb 15, 2019 at 13:28
I can also list using \d myschema.accounts, cannot seem to read the table though — DeclanG
– DeclanG, Commented Feb 15, 2019 at 14:31

John Rotenstein · Accepted Answer · 2019-02-14 21:16:30Z

0

From Run PostgreSQL queries from the command line:

psql -U username -d mydatabase -c 'SELECT * FROM mytable'

answered Feb 14, 2019 at 21:16

John Rotenstein

273k28 gold badges456 silver badges541 bronze badges

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

2 Comments

DeclanG Over a year ago

Thanks John, I can do this ok when logged in, what im trying to do is run the psql command within the shell script after login to aws rds instance or add to existing connestion string , if I try add this command to script it just stops after login to db until I manully exit, if I try add the -c option to the connection string "psql "host=$RDSHOST port=5432 sslmode=disable dbname=mydbname user=testuser password=$PASSWORD" it complains it does not recognize the -c option

DeclanG Over a year ago

John, You pointed me in the right direction thanks , psql -h $RDSHOST -p 5432 sslmode=disable -d mydbname -U testuser -c 'SELECT * FROM pg_catalog.pg_tables'

Collectives™ on Stack Overflow

Passing psql commands within shell script after connecting to AWS RDS postgres

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related