Questions tagged as 'postgresql'

Tagged questions
1
answer

limiting links in paging php posgresql

I have this code that makes me paging, but I intend to limit the 4 links to each side. Wanted: Previous , 11 , 12 , 13 , 14 , 15, 16 , 17 , 18 , 19 , Next Current code: $qry1= pg_query($dbconn,"select * from tabela"); $reg...
asked by 13.08.2018 / 17:09
1
answer

Search inside another scaffold rails

I have a problem, an example I created two scaffold book and loan, then I created a controller and an index called report: rails generate controller RelatoriosEmprestimos index I want to make specific searches of scaffold loans on this cont...
asked by 12.06.2018 / 17:10
1
answer

How do I enable PostGresql on the Cpanel?

Good afternoon. I would like to know how to activate Postgres in the Cpanel menu of the database part, I need to create a database in Pg. I have already installed it in WHM and enabled the configuration, however the option for me to create the b...
asked by 10.04.2018 / 22:00
1
answer

How to save a record in PostgreSQL?

This error occurs when I try to save a record in the PostgreSQL database, I'm using java mai 15, 2018 11:09:18 AM bibliotecapesca.CadastroLeitor BtnSalvarActionPerformed GRAVE: null org.postgresql.util.PSQLException: ResultSet não está posicio...
asked by 15.05.2018 / 16:13
2
answers

How to write a DateTimePicker to the database

Hello, I have a form with DateTimePicker - Short (date only). And in the database I put DataEntrada DATE My problem is, I created an insert method but I do not know how to pass the DateTimePicker by parameter. Method of insert...
asked by 11.10.2017 / 21:44
1
answer

Cursor Trigger in book allocation

Well, I have a table called LOCALAOBOOK in it I have BOOK and CUSTOMER information when an insert or update of allocation occurs, so the customer_id, id_id, the output_data will be informed and from this date the delivery_date_date will be gener...
asked by 29.05.2016 / 20:51
2
answers

How to get data from 3 tables with INNER JOIN in a performatic way

I have three tables in the database, which are Training, Exercise and Exercise_Training . I need to make SELECT with INNER JOIN and differentiate columns with the same name: SELECT t.id AS tid, et.id AS etid, e.id as eid,...
asked by 27.10.2017 / 06:46
1
answer

Use LIKE together with BETWEEN

You can select data with between along with like , for example: public.retornotoner.observacao like between 'A%' and 'Z%' Or is there anything that might look like this? Data example: Vazio Mancha branca Residuo...
asked by 02.03.2018 / 21:03
2
answers

Do a "Update" with a sum of a number that is as a character

I need to do a% with_quality with sum in a table whose column is of type update . Example: UPDATE produto SET codigo = 'codigo'+ 1; I have the following return: UPDATE produto SET codigo = 'codigo'+ 1; ERROR: invalid input syntax f...
asked by 27.07.2018 / 16:06
1
answer

Setar auto-increment in DBeaver

After creating the idpagamentoCielo column as the primary key, I was not able to add the auto-increment property to the column. How can I assign the auto-increment property to the idpagamentoCielo column? Note:...
asked by 04.09.2018 / 14:55