Ruby script cannot find table from PostgreSQL database (PG::UndefinedTable)

Asked Jan 13 '16 at 15:05

Active Feb 13 '17 at 22:17

Viewed 105 times

I'm trying to interact with my PostgreSQL database. I installed the 'pg' gem, and I'd like to execute a very simple script like this one:

require 'pg'
conn = PG::Connection.open('127.0.0.1' , 5432, nil, nil, 'postgres', 'postgres', 'admin')  
res  = conn.exec('SELECT * FROM testtable')

But all I get is:

testdb.rb:4:in `exec': ERROR: relation "testtable" does not exist (PG::UndefinedTable)

If you have any clue or sample code, that would help a lot!

edited Feb 13 '17 at 22:17

asked Jan 13 '16 at 15:05

Roog

Have you created table `testtable`? – Wand Maker Jan 13 '16 at 15:05
Yep of course and a few rows in it. – Roog Jan 13 '16 at 15:09
have you used double quotes during creating table "TestTable" or smth similar? – Dmitry S Jan 13 '16 at 15:10
No. It is all lower case. – Roog Jan 13 '16 at 15:13
Have you created `testtable` in `postgres` database? Your code works for me for a table that I have in my database, so either you using wrong table name or database name – Wand Maker Jan 13 '16 at 15:13
1

I realized I had two conflicted postgres databases on my local host! It is now fixed! Thank you @WandMaker – Roog Jan 13 '16 at 15:35
I'd recommend looking at [Sequel](http://sequel.jeremyevans.net). It's much easier and more portable than using Pg directly. – the Tin Man Jan 14 '16 at 00:04

0 Answers0