Questions tagged as 'postgresql'

Tagged questions
1
answer

How to connect to PostrGreSQL with a python script?

I want to connect to a database with a Python script but I have a problem doing it. I use Psycopg but it returns an exception. Here is the script: #!/usr/bin/python # # Pequeno script para connectarme a PostgreSQL con Pyscopg # import psycopg...
asked by 18.05.2017 / 09:58
1
answer

Filter schedule by date

I need to filter a schedule by dates, in this courses will be registered throughout the year but I need to show only those of the month $fecha_filtro = date('Y/m/d'); if ($fecha_filtro == '05'){ $pg = "select * from cronograma where fecha ili...
asked by 02.05.2017 / 18:06
1
answer

Backup does not store event triggers or extensions

I have a database PostgreSQL (version 9.5), which I need to make a backup, without storing the data of the tables. When doing the backup (from pgAdmin) I select pre-data and post-data . The problem I'm finding is that b...
asked by 22.04.2017 / 18:52
0
answers

Connection to Postgre with JavaScript

Good morning, I need to create a script that makes connection with a postgre database , so that when you run capture a value that is in the database . Someone knows the code that allows me the connection and the query through Javascript ....
asked by 04.04.2017 / 12:38
0
answers

Return text in plpgsql?

I am doing an exercise for class in which they ask me the following:    Create a function that returns a text with a list of the notes of a   student indicated by parameter. The input parameter is mandatory.   You have to return null if the p...
asked by 29.03.2017 / 14:49
0
answers

Problems when exporting data to csv file

I have my postgrSql database from where I need to extract my data to a csv file but at the moment of executing the command I am presented with the following message: ERROR: no se pudo abrir el archivo «C:\Users\TECSINFO\Desktop\archivo\pru...
asked by 04.10.2017 / 21:24
1
answer

Datetime C # - Timestamp Postgresql

I have a problem inserting the date in PostgreSQL, I have the following: parametros.Add("descripcion", this.descripcion); parametros.Add("fecha", this.fecha); parametros.Add("estado", this.estado); Program.da.SqlQuery("insert into schtiempos....
asked by 26.03.2017 / 14:11
1
answer

Help! problems with apache2 / php5 / PostgeSQL on Debian 6

For some time I have tried to solve this problem, and little by little I lose hope and I go into despair, I CLARIFY! I am NOT an assiduous user of Linux or any of its distributions (and I do not want to) it is just work, any answer please if it...
asked by 25.03.2017 / 03:17
1
answer

Blocks pl pg sql

I am starting to use plpgsql and postgresql and the truth is that I am a bit lost, I have an exercise in which I am asked to make a block that increases the salary of the employees by 10% of the average salary of the same, and I have done this:...
asked by 15.03.2017 / 15:47
1
answer

how to make a PG_DUMP from a script, that allows me to choose which database to ignore and which ones do not

I am developing a Script in the Bash , for the automation of the creation of the Backups for the Postgresql engine. strong> in Centos , but I need to be able to ignore the databases that you define in a variable. and save the Dump in th...
asked by 10.05.2017 / 15:21