reset password
Author Message
calikidd
Posts: 41
Posted 13:46 Sep 29, 2010 |

Can PostgreSQL be install a flash drive?

cysun
Posts: 2935
Posted 13:54 Sep 29, 2010 |

I think it's possible, but you'll have to at least know how to start the server from command line because the server won't be running as a service. It's probably not worth doing.

calikidd
Posts: 41
Posted 14:30 Oct 12, 2010 |

I was watching the video and following the steps, but I got to the command prompt and type in "psql template 1" I got an error saying 

   'psql' is not recognized as external or internal command, operable program or batch file. 

Do you know of a way to fix this?

calikidd
Posts: 41
Posted 14:33 Oct 12, 2010 |

Another question, after installing PostgreSql, do we have 3 options to run our queries?

 

which is best for the class or does it matter?

cysun
Posts: 2935
Posted 14:42 Oct 12, 2010 |
calikidd wrote:

Another question, after installing PostgreSql, do we have 3 options to run our queries?

 

which is best for the class or does it matter?

After you install PostgreSQL, both psql and pgAdmin are available, but phpPgAdmin must be installed separately.

I prefer psql because I think it's faster and easier, but if you prefer GUI you can use pgAdmin.