Questions tagged as 'postgresql'

2
answers

How to create tables in postgreSQL using automatic generation of primary key id?

I want you to forgive me for this post, maybe it's somebody's doubt, but come on ... I know that the programmer has to master some things, and these things are considered as trívias, for example; Every programmer has to know advanced English...
asked by 21.06.2017 / 19:32
2
answers

Field Size error when executing Insert in PostgreSQL in Delphi application

I have a problem that could only be happening on a Friday # 13. I have a Delphi application that controls SEDEX submissions and I use the PostgreSQL Database. In a given column, called sdx_cepnet , I store the information that the Barcode...
asked by 13.11.2015 / 23:02
4
answers

Copy data from one database to another postgress

How do I copy data from one table from one database to another table in another database in postgress Is it possible to do something like? INSERT INTO V(ID,D,S) VALUES(SELECT ID,D,S FROM D.A)     
asked by 17.11.2015 / 13:47
3
answers

Capture selected value in grid checkbox

Hello, I have the above form where it shows all the products that I have registered in my database and presents in a Gride. I placed the checkbox inside this Gride. I would like you to only record items that are checked out of the check...
asked by 20.10.2015 / 03:32
2
answers

Concatenate columns in a single Postgresql row

I have a situation that would make it much easier .. if I could return the data of a specific column in a single line: For example: Table A: Codigo | Descricao ------------------- 1 | Descricao 1 2 | Descricao 2 3 | Descri...
asked by 23.06.2017 / 16:57
2
answers

Making PostgreSQL database data visible or not, without deleting, is it possible?

I have an application where in addition to registering and consulting clients, it allows to issue reports with the information of the clients, the problem is that many of these customers already registered do not have more importance for the cur...
asked by 01.12.2016 / 14:43
3
answers

Delete duplicate table record in PostgreSql

Situation I have now performed a two-time process where it should be processed only once. So my table was populated twice with the same data. tb_kardex cd_kardex | cd_item tb_kardex | 1 | 45875 | | 2 | 45876 | | 3 | 45877 | | 4 | 45875 | |...
asked by 09.12.2015 / 18:18
3
answers

Problem with sorting in PostgreSQL

I have a problem when ordering columns in PostgreSQL even though it is properly configured in UTF-8. The version of PostgreSQL is 9.3 and it is installing on a Maverick 10.9.5 MacOSX (this problem has already occurred in earlier versions of t...
asked by 29.09.2014 / 21:23
2
answers

Decimal variable removing the decimal places

I have a variable in decimal that receives a value from a textbox , but when this variable receives the value with decimal places it removes the decimal place and stores the value without it. p> What happens: TextBox value: 2.5;...
asked by 27.01.2015 / 13:15
2
answers

Delete specific word from a string

Good evening, everyone. I'm having an issue that is as follows: I need to remove the ' <br> ' tag at the end of the data in my database (PostgreSQL), due to the text editor it automatically places. I could not create anything c...
asked by 05.11.2015 / 01:35