Postgresql psql command dumping error

Question

im trying to export my table from Postgresql (RDS) on Amazon Web Services using the following command:

psql -t -A -F"," -c "select * from Album" > album.csv -h amazon-instance -p 5432 -U username -W -d chinook

I get this error message:

ERROR:  relation "album" does not exist
LINE 1: select * from Album

The reason for that error message is that my table starts with a capital (A)lbum so how can I escape my command to make this work?

Thank You

Yes I have this table but it starts with upper 'A' so postgres does not recognize the upper characters. — user1896576
– user1896576, Commented Jan 23, 2016 at 17:18
Search postgresql.org/docs/current/static/sql-syntax-lexical.html for "quoting an identifier". — Mike Sherrill 'Cat Recall'
– Mike Sherrill 'Cat Recall', Commented Jan 23, 2016 at 17:21
Bingo got it working, escaped my command like this: -c "select * from "\""Album\"" — user1896576
– user1896576, Commented Jan 23, 2016 at 17:24

user1896576 · Accepted Answer · 2016-01-23 17:34:21Z

3

I had to escape the capital letter in the Album table on my psql command as follows:

psql -t -A -F"," -c "select * from "\""Album\"" > album.csv -h amazon-instance -p 5432 -U username -W -d chinook

answered Jan 23, 2016 at 17:34

user1896576

751 silver badge10 bronze badges

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

1 Answer 1