up vote 0 down vote favorite

I am beginner to PostgreSQL.

I want to connect to another database from the query editor of Postgres - like the USE command of MySQL or MS SQL Server.

I found \c databasename by searching the Internet, but its runs only on psql. When I try it from the PostgreSQL query editor I get a syntax error.

I have to change the database by pgscripting. Does anyone know how to do it?

link|improve this question
feedback

1 Answer

up vote 1 down vote

When you get a connection to PostgreSQL it is always to a particular database. To access a different database, you must get a new connection.

Using \c in psql closes the old connection and acquires a new one, using the specified database and/or credentials. You get a whole new back-end process and everything.

link|improve this answer
Thanks kgrittn for your valuable guidance.Can you tell me how I can make new connection to database and close previous by using pgscript query? – user1358896 Apr 27 at 6:41
I'm not familiar with pgscript. If that's a language in which you write functions, the answer is that it can't be done. Maybe you should consider putting tables in different schemas instead of different databases? – kgrittn Apr 27 at 12:40
Thanks.can we write simple query to change database???How? – user1358896 Apr 27 at 13:39
A query can't change the database in PostgreSQL. – kgrittn Apr 28 at 1:04
Thanks kgrittn for all your help.. :) – user1358896 Apr 30 at 8:25
show 1 more comment
feedback

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.