Say I need hand write some queries in the console, what's the most efficient way of executing multiline queries like CREATE TABLE
statements?
I am used to using Microsoft Management Studio, but I now find myself having to learn about PostgreSQL on the fly.
#
prompt appears only enter one line at a time which is great for things likeCREATE DATABASE
orALTER USER
. How would I be able to nicely format my text before executing?