PostgreSQL Database Forum

How can I calculate the number of second in some interval? Neither the secods part, nor the seconds after midnight... Just the full quantity of the seconds. I haven't find any function. Thanks in advance. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

I'm running Postgres 7.1.3, and just started having a problem where my dynamic site is going down (read-only DB, with no writes happening to the DB) regularly (every other day). I have no idea whay this is happening, and my search of the FAQ's and mail list don't bring up anything. i've attached the error from the log file, at the end of...

Hi, I'm trying to compare a timestamp to current_timestamp but I'm having trouble. I want to compare just the date piece of my timestamp column to just the date piece of current_timestamp. I'm getting weird results that I don't understand. When I use TO_DATE it changes the year, month, etc. Any ideas?

I want to import a schema from database to another, how can I do that? Thanks.

Is there an easy way to pipe a select statement's output to a file? -- http://www.sugapablo.com <--music ] http://www.sugapablo.net <--personal ] sugapablo@12jabber.com <--jabber IM ] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Is there a way to make Postgresql case-INSENSITIVE? Thanks

Dear all, i have a column with data type array with variable size ...... e.g number = i want to access the last element of this array....... i accessed the first element by following statement.... select * from student where number = this worked fine....

i want to append the string which is present in the stored pocedure to SQL query CREATE OR REPLACE FUNCTION sample(fid varchar,ioffset int) RETURNS SETOF totaltype AS $$ DECLARE s totaltype %ROWTYPE; SQL_Tx_Type VARCHAR(4000);

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I want to change a column from text to bytea; since it seems that alter table can't change the column type, i have to add a temporary column and copy the data from the old one to the new, delete the old and rename the new.

I am creating a C# .NET application that uses a postgreSQL database that is on my machine locally. My problem is that I cannot figure out how to write the connectionString. I have searched the internet for the past 30 minutes trying everything I could find. Help? anyone? public class Connection { protected static SqlConnection...

Hai, can anyone tel me what dose this error mean. 'more' is not recognized as an internal or external command, operable program or batch file.

I just installed PostgreSQL on ubuntu linux. the installer does everything for, but I try to use "createuser" I get this message: { FATAL: role "root" does not exist } I have tried different suggestions from the Net, nothing seems to work. How do I correct the problem?

Hi all, I am using postgresql7.4. How to handle arrays in plpgsql. How can I pass an array. Is it possible to retrieve values from an array by indexing it like argument : '{1,2,3}' Return value : varchar array Variables : ---------

Is there a way to replicate one-off(a copy of duplicate) of an existing Postgres database. regards, caroline __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software

Hi Forum, I'm trying to perform a type of concatenate function on a table and am not really sure where to start. I'd like to aggregate the values from 'field' on their ID. To explain, my table is like this: ID roadnum 1 A-1 2 B-1 2 E-1 3 N-1 4 N-3

How to write a single update sql statement to update different set of attributes of a table. In other words what will be the value of indicator variables to ignore updates of some attributes in a update statement. e.g. EXEC SQL UPDATE vA:iA vB:iB vC:iC in TABLE 1 where vD = ...

Someone know how to create database in postgreSQL through Java code? How to check particular database exist or not in postgreSQL through java code?

Hi All, I am not sure how to change the date format in PostgreSQL. I have the dates stored in the database as yyyy-mm-dd HH:MM:SS+TimeZone to get the GMT time (Ex: 2008-02-28 14:03:23+05:30). But I want these dates to be shown in the following format: dd/mm/yyyy HH:MM:SS TimeZone (Ex: 28/02/2008 14:03:23 IST)So now while I am trying to fetch...

Hi In postgresql database how to retrieve the date in a required format ? Is ther any method to retrieve the stored date value in mm/dd/yyyy format. I don't want to set the date format in postgres databse . Whatever format the date value stored , is there any method to retrieve the date in any required format ? Pls post your replies Thank...

I am using postgresql 10, and when I created a table with two variables, the lock signs(shows read-only column) were shown on the columns. I am not sure if it is a reason that makes me can not import csv file into table. if so, how can I remove that? https://i.stack.imgur.com/kIiRX.png

Hey all. I've hit an SQL problem that I'm a bit mystified by. I have two different questions regarding this problem: why? and how do I work around it? The following query: SELECT GCP.id, GCP.Name FROM Gov_Capital_Project GCP,

Hi, all I am new for psql and here is my problem. I created a new psql user with no superuser no role creation and no DB creation. So when the new user tries to query a table and got: postgis_test_db=> SELECT vessel_name, time, position FROM current_position; postgis_test_db=> ERROR: permission denied for relation current_position Any...

I have a server under very light load -- just me doing some work in php. I am getting this error often and don't know why: postgresql max connections Unable to connect to PostgreSQL server: FATAL: Sorry, too many clients already my postgresql.conf had: max_connections = 8 shared_buffers = 16

Why happens this? Warning: pg_connect() unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "bchytrek" in /var/www/html/physio2/test.php on line 19 The php-statement is : $conn = pg_connect("dbname=testdb user=bchytrek");

Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). Regards, Marcelo Pereira Brasil