Postgresql – call multiple Sql files in a single SQL file in Postgres

postgresql

How do call multiple sql files in a single sql file, in postgres

For example I have aaa.sql, bbb.sql, ccc.sql.

I want to execute this 3 files from xxx.sql.

Can anyone suggest me how to do this.

Best Answer

If you are running these files through psql you want the \i directive ("execute commands from file").

xxx.sql:

\i aaa.sql
\i bbb.sql
\i ccc.sql

If you are passing these through some other program you will need to combine the files yourself - I do not believe there is any SQL-standard way of executing external files.

Related Solutions

Mysql – Postgres equivalent to MySQL’s \G

I'm not familiar enough with MySQL to know what the \G option does, but based on the documentation it looks like the psql \x option might do what you want.

It's a toggle, though, so you do it before you submit the query.

\x
select * from sometable;

Debian – How to import Postgres data dumps into MS SQL

On SQL Server you could use SSIS to parse the CSV files and load them into tables. If they are in the proper format to start with, you can use bulk import on the sql server side for fast load from a script.

That is about the best 2 says I can easily see ;)

Best Answer

Related Solutions

Mysql – Postgres equivalent to MySQL’s \G

Debian – How to import Postgres data dumps into MS SQL

Related Topic