My query (to create a new table from existing table) takes a very long time. So I've set up a remote database in my office - more RAM there.
I can connect to my database from home as usual with psql.
How can I tell the remote server to execute my query from the terminal without having to wait for a response?
(postgresql-9.2 , linux enviroment)
Edit: I'm open to other solutions, it's not necessary to use psql