Questions tagged as 'postgresql'

Tagged questions
0
answers

Laravel 5.2 ErrorException Undefined index: username

I followed this guide " link " to make the connection ldap with laravel and postgres but when I write The name of user and the password on the page, shows me this error and I have no idea what to do. Any idea what it could be? This is the...
asked by 23.10.2017 / 18:03
1
answer

Install pgadmin 4 win 2008 R2

I know the question is not specific to programming, but suddenly someone can help me: Install pgadmin 4 version 2.0 on a server with Windows 2008 R2, I do not generate any warning during the process, but when launching the application I get t...
asked by 06.10.2017 / 18:51
1
answer

I can not back up the database with PostgreSQL

When trying to backup my database, the following message is presented: my operating system is windows and I am using pgAdmin III. Someone who can help me, thank you.     
asked by 29.09.2017 / 17:48
1
answer

error in SQL server in query to a linked server

Good afternoon, I have linked sqlServer with PostgreSQL, the connection is successful, I can see the databases that I have in PostgreSQL except for the database tables, otherwise it is when I want to access the tables in the database that comes...
asked by 28.09.2017 / 22:41
0
answers

How to run an Update in .bat file

I'm trying to generate a bat file, where you enter my postgres database and run an update referenced to a SET, I enclose my sentence @echo off set /p OPERACION=¿CUAL ES EL NUMERO DE OPREACION QUE DESEAS HABILITAR RESPUESTA?: cd C:\Program F...
asked by 28.09.2017 / 15:41
0
answers

Java Jtable Editable in execution time BD postgresql

I only have one Jtable created, I need to visualize and update the data in this one that must be connected to Postgresql It's all the code I have package sistema; import java.sql.ResultSet; import javax.swing.table.DefaultTableModel; /**...
asked by 23.09.2017 / 01:30
3
answers

sort rows in columns in postgresql

I have a table where I keep track of nutritional evaluations of people, each person can have between 1 to 6 evaluations and all are stored in that table, what I want to do is that moment to download this information bring me the data of the pers...
asked by 18.10.2017 / 17:45
1
answer

Link PostgreSQL and SQL server express 2012

Good afternoon, I would like to know if it is possible to link my local database (PostgreSQL) with SQLExpress 2012 (I am downloading to install). The same tables that I have in PosgreSQL have them in SQLExpress 2012, if I add a data in SQLExpres...
asked by 20.09.2017 / 21:19
1
answer

Receive postgres table in java

I have the following function in postgresql: CREATE OR REPLACE FUNCTION public.sp_sel_categoria(IN _codigo integer) RETURNS TABLE(acat_cod smallint, acat_nombre character varying, acat_descrip character varying) AS $BODY$ BEGIN IF _codigo =-1...
asked by 19.09.2017 / 20:43
1
answer

Problem in complex consultation Postgresql (Odoo)

I have a problem with a complex query. It's about seeing all sales orders. The query is for an ERP called Odoo: CREATE OR REPLACE VIEW public.ordenes_de_venta AS WITH tabla as ( SELECT po.id pos_id, sp_fecha(to_char(p...
asked by 16.11.2017 / 00:31