Questions tagged as 'postgresql'

Tagged questions
1
answer

Filtering PostgreSQL information on Windows Forms using Entity Framework

Is there any way to find the information in postgresql by nickname? But without using alias , just in the field record in the table do I already enter the real name for the field? Example:    customer_id will be called "Customer Code"  ...
asked by 17.04.2017 / 22:36
1
answer

How to group by month with SQL?

I have a table, for example, with an attribute nome and data (for example only). I would like to generate a query that returns the quantity of each row grouped by name and month: Nome Janeiro Fev Março Abril Maio ... João 1...
asked by 15.05.2014 / 22:42
2
answers

Sort month that is in extensions in Postgres

I need to make a ORDER BY in a table mes that has the months in extenso and in Portuguese (Janeiro, Fevereiro...) . It has no relation to any other column in the table. Is it possible to do this?     
asked by 20.05.2015 / 15:57
4
answers

How to check the PostgreSQL logs?

I have a legacy database that when doing certain actions on the system that have access to it, several tables are modified, I was able to identify at least 04 tables being changed. My question is is there a log file of PostgreSQL so that I can...
asked by 12.07.2017 / 13:11
1
answer

Different timezones in an application with PostgreSQL

We have a system that serves several distribution centers. A distribution center is a physical location that can be located anywhere in the country. The same customer may have several centers. Our system can work in all these centers. As we are...
asked by 21.02.2018 / 16:58
1
answer

Error in decode and convert_from in Postgres

Has anyone had the problem of Postgres giving base64 decode error? I have the following call that says [Err] ERROR: End of sequence is invalid convert_from(decode('YnJhc2lsc2VtbGVp', 'base64'), 'UTF8') Remembering that where I have 'YnJh...
asked by 27.11.2014 / 15:37
2
answers

Pass parameter of type ROWTYPE with the EXECUTE command

I am developing a function in Postgres that aims to retrieve for each record of a query the result value of a scan contained in a set of functions. Of these functions only one will return the correct value. These functions have a common prefix '...
asked by 21.01.2016 / 19:14
4
answers

Select with undefined number of conditions

It's the following, I have a search field, and I want to search in places other than what is registered, type like: tenis nike shox preto . I put in the search: tenis preto . If I use a like '%tenis preto%' description it will no...
asked by 16.10.2014 / 08:30
2
answers

select from date in the postgreSQL database

How do I make a select in the postgreSQL database for it returns the data from a specific date, for example I have a field of type timestamp with name data_interview, I want it to bring me the data registered from the present day forward . SEL...
asked by 19.10.2016 / 18:46
2
answers

How to install the PDO_PGSQL driver in ubuntu?

I have already installed PHP 7, Apache 2 and Postgresql 9.5. I have already enabled the extension in php.ini but it does not work. In Windows just enable this extension in php.ini that already works but here in Ubuntu was not...
asked by 13.09.2016 / 17:44