SELECT query not working is pgrouting

Asked Sep 07 '15 at 03:48

Active Sep 07 '15 at 03:48

Viewed 118 times

I was just going through this tutorial HERE, its about pgrouting and basically when i run the following command:

SELECT * FROM types ORDER BY id;

I get an error saying SELECT: command not found, in the documentation the following is said:

Note We switch now to the database we previously generated with osm2pgrouting. From within PostgreSQL shell this is possible with the \c routing command.

now when i run the command \c routing from my terminal i get the following error:

c: command not found

Well so to sum up my difficulty, how do i get the select query working ?

SCREENSHOT HERE

Thank you.

Alex-z.

asked Sep 07 '15 at 03:48

Alexander Solonik

9,838
18
76
174

Before you can work with pgrouting, you need at least a basic PostgreSQL / psql experience. Try this tutorial: http://www.postgresql.org/docs/9.4/static/tutorial.html – Tom-db Sep 07 '15 at 06:02
@TommasoDiBucchianico , that was very kind of you thanks ! :) – Alexander Solonik Sep 07 '15 at 06:15
You quit the psql with `\q` that's selects don't work after that. Please be more careful where you run your commands, you can hurt a server. – Jakub Kania Sep 07 '15 at 07:23
@JakubKania hurt a server ??? – Alexander Solonik Sep 07 '15 at 07:41
1

@AlexanderSolonik Just kidding mostly. But, yeah, you run the commands not where you intended to, you can break something by accident. – Jakub Kania Sep 07 '15 at 07:44

SELECT query not working is pgrouting

0 Answers0