postgresql Archives - Page 5 of 21

MySQL, Programming

IT Nursery

What resources exist for Database performance-tuning? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

IN vs ANY operator in PostgreSQL

What is the difference between IN and ANY operator in PostgreSQL? The working mechanism of both seems to be the same. Can anyone ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

How to add “on delete cascade” constraints?

In PostgreSQL 8 is it possible to add ON DELETE CASCADES to the both foreign keys in the following table without dropping the ...

May 28, 2022
0 Comments

performance, Programming

IT Nursery

postgresql COUNT(DISTINCT …) very slow

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 ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

ORDER BY the IN value list

I have a simple SQL query in PostgreSQL 8.3 that grabs a bunch of comments. I provide a sorted list of values to ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

Group query results by month and year in postgresql

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 ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

How to display the function, procedure, triggers source code in postgresql?

How to print functions and triggers sourcecode in postgresql? please let me know if any one know the query to display the function, ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

Find the host name and port using PSQL commands

I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to find the ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

psql: FATAL: Peer authentication failed for user “dev”

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 ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

How to see the CREATE VIEW code for a view in PostgreSQL?

Is there an easy way to see the code used to create a view using the PostgreSQL command-line client? Something like the SHOW ...

May 27, 2022
0 Comments