Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to … Read more
What is the difference between IN and ANY operator in PostgreSQL? The working mechanism of both seems to be the same. Can anyone explain this with an example? 2 Answers 2
In PostgreSQL 8 is it possible to add ON DELETE CASCADES to the both foreign keys in the following table without dropping the latter? # \d scores Table “public.scores” Column | Type | Modifiers ———+———————–+———– id | character varying(32) | gid | integer | money | integer | not null quit | boolean | last_ip … Read more
I have a very simple SQL query: SELECT COUNT(DISTINCT x) FROM table; My table has about 1.5 million rows. This query is running pretty slowly; it takes about 7.5s, compared to SELECT COUNT(x) FROM table; which takes about 435ms. Is there any way to change my query to improve performance? I’ve tried grouping and doing … Read more
I have a simple SQL query in PostgreSQL 8.3 that grabs a bunch of comments. I provide a sorted list of values to the IN construct in the WHERE clause: SELECT * FROM comments WHERE (comments.id IN (1,3,2,4)); This returns comments in an arbitrary order which in my happens to be ids like 1,2,3,4. I … Read more
I have the following database table on a Postgres server: id date Product Sales 1245 01/04/2013 Toys 1000 1245 01/04/2013 Toys 2000 1231 01/02/2013 Bicycle 50000 456461 01/01/2014 Bananas 4546 I would like to create a query that gives the SUM of the Sales column and groups the results by month and year as follows: … Read more
How to print functions and triggers sourcecode in postgresql? please let me know if any one know the query to display the function, triggers source code. 9 Answers 9
I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to find the current port and host that the database is running on? 15 Answers 15
when i create a new user, but it cannot login the database. I do that like this: postgres@Aspire:/home/XXX$ createuser dev Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) y then create … Read more
Is there an easy way to see the code used to create a view using the PostgreSQL command-line client? Something like the SHOW CREATE VIEW from MySQL. 9 Answers 9