psql

\password psql will prompt you for a password and then prompt you to reenter it (remember this password, because you will need it later).

Citizendium, the Citizens' Compendium - Recent changes [en] Dan Nessett 2009

The main command line utility for interacting with postgres is "psql".

Citizendium, the Citizens' Compendium - Recent changes [en] Dan Nessett 2009

# Create the table echo "Creating $TABLE" shp2pgsql - s 4326 - I - S - c - W UTF-8 "/tmp/$ {BASE}. shp" $TABLE | psql $DATABASE fi

Planet Geospatial Tim Sutton 2010

I can list them through the psql console, but I cannot do that in a shell script.

LinuxQuestions.org Shreerang Patwardhan 2010

# Append to the exisitng table echo "Appending to $ {TABLE}" shp2pgsql - s 4326 - I - S - a - W UTF-8 "/tmp/$ {BASE}. shp" $TABLE | psql $DATABASE else

Planet Geospatial Tim Sutton 2010

There were just two main issues with the update: the easy one is that the users don't get activated after migration, which means you cannot login, a psql call after and I'm back in; the other problem is that the Atom feed generated was invalid, because to replace the

Flameeyes's Weblog : 2009

Once psql is connected to the postgres database using the Login Role postgres, it is possible to change the password for (the Login Role) postgres.

Citizendium, the Citizens' Compendium - Recent changes [en] Dan Nessett 2009

It is recommended that those unfamiliar with psql read this good tutorial on its use.

Citizendium, the Citizens' Compendium - Recent changes [en] Dan Nessett 2009

Seperti halnya MySQL dan Microsoft SQL Server, kita dapat berinteraksi dengan basis data pada Postgres menggunakan perintah-perintah disisi klien dengan tool yang disebut psql.

Recently Uploaded Slideshows 2009

A way to get a list of databases in a useful format for scripting can be done with this command: psql - username = USERNAME - P format = Unaligned - tqc 'SELECT datname FROM pg_database;'

almost effortless 2009