for PostgreSQL questions specific to version 9.1.
What command or short key can I use to exit the PostgreSQL command line utility psql?
postgresql postgresql-9.1 psqlI either forgot or mistyped (during the installation) the password to the default user of Postgres. I can't seem to …
postgresql postgresql-9.1 forgot-passwordI have a table that looks like this caller 'makerar' cname | wmname | avg --------+-------------+------------------------ canada | zoro | 2.0000000000000000 spain | luffy | 1.00000000000000000000 …
sql group-by aggregate-functions postgresql-9.1I am beginner to PostgreSQL. I want to connect to another database from the query editor of Postgres - like …
postgresql postgresql-9.1When I do a \dt in psql I only get a listing of tables in the current schema (public by …
postgresql postgresql-9.1 psqlHow do I convert an integer to string as part of a PostgreSQL query? So, for example, I need: SELECT * …
postgresql postgresql-9.1How to assign the result of a query to a variable in PL/pgSQL, the procedural language of PostgreSQL? I …
database postgresql stored-procedures plpgsql postgresql-9.1I have a small table and a certain field contains the type "character varying". I'm trying to change it to "…
postgresql casting postgresql-9.1 fieldtypeI have a Postgres db 9.1 running on AWS EC2, with ubuntu 12.04. I messed a lot with the instance (i.e …
ubuntu ubuntu-12.04 postgresql-9.1Is there any shorter way to look for multiple matches: SELECT * from table WHERE column LIKE "AAA%" OR column LIKE "…
sql postgresql postgresql-9.1