postgresql Archives - Page 10 of 21

I am testing Postgres insertion performance. I have a table with one column with number as its data type. There is an index ...

In postgresql, how do I replace all instances of a string within a database column? Say I want to replace all instances of ...

I am using PostgreSQL via the Ruby gem ‘sequel’. I’m trying to round to two decimal places. Here’s my code: SELECT ROUND(AVG(some_column),2) FROM ...

I have a Postgresql database on which I want to do a few cascading deletes. However, the tables aren’t set up with the ...

I am working on Django project with virtualenv and connect it to local postgres database. when i run the project is says, ImportError: ...

Are timestamp values stored differently in PostgreSQL when the data type is WITH TIME ZONE versus WITHOUT TIME ZONE? Can the differences be ...

I’m trying to run the following PHP script to do a simple database query: $db_host = "localhost"; $db_name = "showfinder"; $username = "user"; ...

I would like to get the columns that an index is on in PostgreSQL. In MySQL you can use SHOW INDEXES FOR table ...

I have been facing a strange scenario when comparing dates in postgresql(version 9.2.4 in windows). I have a column in my table say ...

Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and ...