Questions tagged as 'postgresql'

Tagged questions
1
answer

Reducing quantities of rows in a query

On my system I have 3 tables: -Table Movie - A movie featuring multiple artists -Tabela Artist -Table Participates Movie - This table contains the ID's of the movie and artist table. Then when I want to select a movie with all your a...
asked by 04.03.2017 / 14:38
1
answer

Insert with datatime Postgresql and C #

I would like to ask a question, why does not the first date work?    Cmd.Parameters.AddWithValue ("@ dtUltAccess", "2017-01-01 01: 01: 01 + 09"); Error returning:    Error inserting user - Error: 42804: column "usu_dataacesso" is of   ...
asked by 17.03.2017 / 01:24
1
answer

Scheduling System Windows, SQL

How do I make create and run a sql (postgresql) command in the windows scheduling system? My problem. I have a postgresql database where I have two tables. One is a client and the other is a disk location. I need to know if the location...
asked by 15.02.2017 / 15:38
2
answers

Show latest results postgresql

I need to display the last 5 results of a query, but I do this query twice because I need to change the where clause to return the values I need. I thought of something like: SELECT id, project_id, name, subject FROM "issues" where project_...
asked by 20.03.2017 / 15:26
1
answer

Error passing script from a Firebird database table to PostgreSQL

I'm trying to pass a script to create and insert data from a Firebird database to PostgreSQL, however in some tables syntax error is occurring, I'm using the SQL Manager Interbase & Firebird to generate the * .sql files from my Firebird data...
asked by 07.12.2016 / 16:51
1
answer

Assign a value to a Boolean variable according to Radio Button selected

I'm trying to implement my application, where the empresa table has gained a new column named status , which would be populated according to Radio Button so that when generating linked client reports, the even if it only brin...
asked by 01.12.2016 / 19:17
1
answer

Incremental Backup Postgresql PITR

I have an incremental backup routine running daily saving Postgresql logs . Every morning the full backup is performed: pg_start_backup() tar -cvzf /usr/local/pgsql/pgDataPITR/pgdatabk.tar /usr/local/pgsql/pgDataPITR/ select pg_stop_b...
asked by 02.11.2016 / 15:01
1
answer

Connection Problems pgsql in Laravel 5.1

I am trying to connect to the pgsql database by Laravel 5.1 but an error is appearing:    PDOException in Connector.php line 55:   SQLSTATE [HY000] [1045] Access denied for user 'root' @ 'localhost' (using password: YES) -    in Connec...
asked by 28.12.2015 / 14:38
1
answer

SELECT with REGEXP

Next, I have a people table: [name, enrollment, cpf] What happens is, some people who have the "same" cpf have different license plates. The [same] is in quotation marks, because in the database, there are cpfs like in this example: 1)...
asked by 18.11.2016 / 02:44
1
answer

Android - Connecting with PostgreSQL

I'm trying to connect Android directly to PostgreSQL . Include in the project package: postgresql-9.1-903.jdbc4.jar and I'm using PostgreSQL 9.1 . But I can not successfully connect. I modified the code and it returns...
asked by 19.09.2016 / 17:34