Questions tagged as 'postgresql'

Tagged questions
2
answers

Execute SQL command in terminal

I'm trying to run sql command through the windows prompt but I do not know the initial settings to do this. Can anyone tell me? Detail: It must be in the windows terminal.     
asked by 16.02.2017 / 14:16
1
answer

Query to separate records

Good afternoon guys, I'm having a hard time doing a query. Have the following table Iwouldliketomakeaquerythatshowswhatandhowmanystatus_telephonyhadbyphoneanddate,thencreateatablewithallphonesthathadmorethan5OR+status"MACHINE" OR "INVALID...
asked by 14.02.2017 / 20:17
2
answers

Failed to make a change to the database

When I make a Update in the Impressora table my program is closing itself, when debugging the program the following error was accused: MyUpdatelookslikethis:beginifcdsImpressora.statein[dsedit]thenbegindmDatabase.SQLConnection....
asked by 13.01.2017 / 11:59
2
answers

Generate backup of a PostgreSQL Server with password via command line

I need to automatically back up a PostgreSQL server, I have a command that does this backup but it always asks me for the password and I did not find a command where I can already determine the password of the database already in Script . The c...
asked by 03.01.2017 / 17:04
1
answer

How to assign query cost to a variable in Postgres

To get the estimated cost of the query I use EXPLAIN SELECT coluna FROM tabela; , to get the current cost of the query I use EXPLAIN ANALYSE SELECT coluna FROM tabela; , my question is how to fetch the cost of the query automatic...
asked by 26.09.2016 / 22:49
2
answers

Group two tables

I have two tables. One call Pessoa and another call Evento . Pessoa has the id , name , and email fields. Evento has the fields id and pessoa_id . The Evento table contains...
asked by 15.08.2016 / 14:32
1
answer

Migrate Firebird Delphi 7 Application to PostgreSQL

I'm trying to migrate an application that was developed in Delphi 7 and uses Firebird to save your information to the postgreSQL database, I have already been able to connect postgreSQL with Delphi with the help of ZeosLib, but this applic...
asked by 20.10.2016 / 21:31
1
answer

Excess symbol% within LIKE

We have a system in GX EV3 u2 generating Java and connecting to Postgresql 9.3. Overall the performance is acceptable, but at certain times we have bottlenecks and I noticed that they happen just when a query with LIKE is executed. Looking fur...
asked by 04.05.2016 / 14:54
1
answer

manipulating dates in postgresql

I have a database with multiple records, from 2001 to 2010 . How do I select all tuples with dates after day 2001-05-02 ? Date is of type character varying(254) .     
asked by 25.05.2016 / 20:37
1
answer

How to treat data from a Date lookup in the where clause in Postgres?

I have a screen where you have a list of payment titles for a company, and I need to do a dynamic search from the issue date of the title. The idea is that when the user enters the date in a search field, this data will be passed dynamically via...
asked by 23.10.2015 / 15:05