How to run psql commands in a PHP script?

Question

I need to run some commands which are not part of SQL, eg: \d (describe)

One normally runs such commands by first connecting to the database using the psql client, in the command line.

But now I need to do it programatically, using a script. How can I do this? I know about exec(), but psql isn't a normal command. It opens a client in the console, and THEN you run your commands. Kind of like ssh.

psql is a "normal command". It doesn't need a terminal on it's stdin/stdout, and psql databasename <inputfile >outputfile works as expected. (but you will need to quote the backslashes at some point(s) ) — joop
– joop, Commented Dec 11, 2015 at 14:40

Ryu · Accepted Answer · 2015-12-11 19:34:42Z

1

The -c option solved it.

psql [...] -o output.txt -c "\d mytable"

edited Dec 11, 2015 at 19:34

answered Dec 11, 2015 at 15:00

Ryu

214 bronze badges

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

Collectives™ on Stack Overflow

How to run psql commands in a PHP script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related