Execute sql file to specific schema with psql

1
psql "dbname=mydatabase options=--search_path=myschema" -a -f myfile.sql
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Source: http://stackoverflow.com/questions/13770944/how-can-i-specify-the-schema-to-run-an-sql-file-against-in-the-postgresql-comman#13770991

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.