Tag: postgresql

1620 How to exit from PostgreSQL command line utility: psql 2012-02-27T10:17:44.657

1572 PostgreSQL "DESCRIBE TABLE" 2008-09-20T20:47:48.917

1321 Show tables in PostgreSQL 2009-04-20T19:07:39.210

972 Select first row in each GROUP BY group? 2010-09-27T01:23:22.873

862 How to switch databases in psql? 2010-10-16T17:09:34.107

807 How to start PostgreSQL server on Mac OS X? 2011-11-02T03:36:43.580

772 Drop all tables in PostgreSQL? 2010-07-24T23:24:05.433

726 Save PL/pgSQL output from PostgreSQL to a CSV file 2009-10-04T22:58:51.100

726 Which version of PostgreSQL am I running? 2012-12-05T22:34:16.760

655 Can't find the 'libpq-fe.h header when trying to install pg gem 2011-05-18T06:11:09.647

634 How to change PostgreSQL user password? 2012-10-04T05:45:39.323

614 Creating a copy of a database in PostgreSQL 2009-05-18T07:00:17.783

559 postgres: upgrade a user to be a superuser? 2012-05-25T15:43:18.613

544 Insert, on duplicate update in PostgreSQL? 2009-07-10T11:38:49.187

532 PostgreSQL error: Fatal: role "username" does not exist 2012-08-12T03:00:44.830

531 How to drop a PostgreSQL database if there are active connections to it? 2011-03-23T16:03:36.430

525 Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails 2013-09-06T18:15:06.513

523 psql: FATAL: database "<user>" does not exist 2013-07-13T19:18:24.400

499 PostgreSQL Autoincrement 2009-04-24T22:00:42.133

491 How to import CSV file data into a PostgreSQL table? 2010-06-07T06:19:32.873

484 PostgreSQL: Difference between text and varchar (character varying) 2011-01-31T08:44:34.020

456 `pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan) 2014-09-22T08:57:59.823

423 How to reset postgres' primary key sequence when it falls out of sync? 2008-10-28T18:08:21.453

408 Copying PostgreSQL database to another server 2009-08-06T08:56:16.287

382 How to do an update + join in PostgreSQL? 2011-10-23T22:09:23.497

358 Run a PostgreSQL .sql file using command line arguments 2012-03-16T11:01:42.600

357 Modify OWNER on all tables simultaneously in PostgreSQL 2009-08-28T16:32:25.640

351 What is this Javascript "require"? 2012-03-28T04:18:58.647

348 Export PostgreSQL table to CSV file with headings 2009-07-13T15:19:35.300

345 How do I (or can I) SELECT DISTINCT on multiple columns? 2008-09-10T15:33:10.890

342 How do you create a read-only user in PostgreSQL? 2009-04-17T12:26:58.123

337 psql: FATAL: Ident authentication failed for user "postgres" 2010-05-31T09:08:14.280

326 How to select the nth row in a SQL database table? 2008-08-19T17:13:11.023

321 import sql dump into postgresql database 2011-07-27T09:50:50.780

318 How to log PostgreSQL queries? 2009-04-06T16:34:32.157

313 Postgres could not connect to server 2012-11-16T04:53:39.753

303 How do you find the row count for all your tables in Postgres 2010-04-07T23:51:29.243

301 Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL? 2009-04-10T10:38:14.153

287 Where are my postgres *.conf files? 2010-08-30T16:48:40.150

285 Postgresql: password authentication failed for user "postgres" 2011-10-08T09:37:43.633

284 Insert text with single quotes in PostgreSQL 2012-09-07T11:11:11.530

278 Where does PostgreSQL store the database? 2009-07-16T11:55:29.970

274 How to concatenate strings of a string field in a PostgreSQL 'group by' query? 2008-09-04T14:27:16.263

271 Kill a postgresql session/connection 2011-02-24T18:30:10.127

271 "use database_name" command in PostgreSQL 2012-04-26T14:30:52.050

254 Best way to select random rows PostgreSQL 2011-12-29T23:30:11.320

253 How to install PostgreSQL's pg gem on Ubuntu? 2010-06-25T06:31:25.400

249 Postgres and Indexes on Foreign Keys and Primary Keys 2009-06-09T14:56:40.663

249 PostgreSQL function for last inserted ID 2010-05-31T14:55:24.117

248 psql: FATAL: role "postgres" does not exist 2013-03-08T19:31:57.607

248 Explanation of JSONB introduced by PostgreSQL 2014-03-26T07:26:42.753

243 Drop postgresql database through command line 2011-08-16T04:59:38.123

240 Postgres DB Size Command 2013-09-20T00:22:23.530

239 How to set auto increment primary key in PostgreSQL? 2011-10-10T20:56:40.197

235 How can I put a database under git (version control)? 2009-05-11T03:49:31.650

234 List tables in a PostgreSQL schema 2013-03-26T17:56:59.277

231 Generating a UUID in Postgres for Insert statement? 2012-09-20T01:53:03.027

230 Permission denied for relation 2013-03-20T10:00:06.543

227 Alternate output format for psql 2012-03-07T15:52:36.253

226 Postgres: INSERT if does not exist already 2010-11-01T14:24:53.857

226 Best practices for SQL varchar column length 2011-11-28T11:26:43.983

224 PostgreSQL: How to make "case-insensitive" query 2011-08-10T02:42:08.433

220 Postgresql: Scripting psql execution with password 2011-06-29T15:16:02.630

219 What is the PostgreSQL equivalent for ISNULL() 2010-02-06T19:59:47.060

217 Check If a Particular Service Is Running on Ubuntu 2013-09-10T14:07:19.243

215 Use email address as primary key? 2010-09-27T13:12:21.047

215 SQL JOIN and different types of JOINs 2013-07-30T11:48:12.387

210 What resources exist for Database performance-tuning? 2009-04-17T16:45:17.097

210 How to UPSERT (MERGE, INSERT ... ON DUPLICATE UPDATE) in PostgreSQL? 2013-06-24T02:56:05.340

207 DatabaseError: current transaction is aborted, commands ignored until end of transaction block 2010-06-05T06:05:19.417

207 How do I specify a password to psql non-interactively? 2011-06-19T21:06:06.343

205 How to pass in password to pg_dump? 2010-05-23T23:32:11.003

204 How to thoroughly purge and reinstall postgresql on ubuntu? 2010-05-01T02:07:08.157

203 Can't subtract offset-naive and offset-aware datetimes 2009-04-28T02:28:08.597

199 How can I add a column to a Postgresql database that doesn't allow nulls? 2009-02-04T17:33:34.243

196 Repairing Postgresql after upgrading to OSX 10.7 Lion 2011-07-21T02:22:16.180

192 Postgresql GROUP_CONCAT equivalent? 2010-04-01T14:09:53.903

192 updating table rows in postgres using subquery 2011-06-06T18:49:02.570

191 Copy a table from one database to another in Postgres 2010-07-07T13:27:58.640

191 psql - save results of command to a file 2011-03-16T20:26:16.293

187 How to generate the "create table" sql statement for an existing table in postgreSQL 2010-04-07T15:38:29.693

186 How do I query using fields inside the new PostgreSQL JSON datatype? 2012-05-12T01:45:13.270

186 Run PostgreSQL queries from the command line 2013-10-30T05:24:40.887

184 What's the fastest way to do a bulk insert into Postgres? 2009-04-17T03:50:46.803

184 Get PostGIS version 2011-01-28T21:36:50.550

182 List columns with indexes in PostgreSQL 2010-02-04T23:39:43.700

182 Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL 2011-05-26T02:32:22.430

182 Optimise PostgreSQL for fast testing 2012-02-23T04:59:33.033

179 How to upgrade PostgreSQL from version 9.6 to version 10.1 without losing data? 2014-06-24T06:03:46.113

178 postgresql - replace all instances of a string within text field 2011-02-20T22:29:07.677

178 Create unique constraint with null columns 2011-11-27T21:16:12.893

174 How to create user for a db in postgresql? 2012-06-02T09:37:44.490

171 Why do we need message brokers like RabbitMQ over a database like PostgreSQL? 2012-10-22T05:28:09.053

166 Installing PG gem on OS X - failure to build native extension 2013-10-09T02:59:36.600

165 Connect to a heroku database with pgadmin 2012-08-02T01:31:29.353

164 How to configure postgresql for the first time? 2009-09-24T13:06:18.187

162 psql: FATAL: Peer authentication failed for user "dev" 2013-07-03T08:39:19.397

160 How to change owner of PostgreSql database? 2010-11-30T11:43:07.270

159 Restore a postgres backup file using the command line? 2010-04-28T19:18:10.693