PostgreSQL: Create schema in specific database [NOT psql]

Question

Im trying to create a SQL file to import my database/schema/tables with PHP.

If I use the PgAdmin, it inserts a meta-command \connect after the CREATE TABLE and this generates an error if I run the SQL with pg_query in PHP.

After read the following questions: PostgreSQL: Create schema in specific database and Postgres Creating Schema in a specific database

I ask: How I can create a new schema, inside specific database, with SQL commands (NOT psql commands)? The specific database is not the default named 'postgres' database, but another created by me.

Jost · Accepted Answer · 2013-07-17 19:34:43Z

4

The short answer is if you are connected to another database you can't with pure SQL.

Due to the fact that there is no use database; in Postgres like in MySQL you have to open a connection to the specific database you want to create the schema in (e.g. with pg_connect in PHP).

The schema itself can be created with the CREATE SCHEMA... sql command as you might know.

Perhaps working with pg_dump and pg_restore is an option for you. I would also have a look at the sources of phpPgAdmin.

I hope that helped a bit.

*Jost

answered Jul 17, 2013 at 19:34

Jost

1,53212 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marcelo Rodovalho Over a year ago

Thanks for the answer! Ill try to do this by another way. Maybe, creating the table first, and after connecting with pg_connect to then run the script to create the schema and tables.

Collectives™ on Stack Overflow

PostgreSQL: Create schema in specific database [NOT psql]

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related