Questions tagged as 'postgresql'

Tagged questions
2
answers

Write data in the database (Value member and Display Member)

I'm having trouble writing this data in the database (Postgresql). In case the data you would like to save are: Customer name Origin, Client name Destination, Order date, Payment date, Confirm payment, Payment method and the Total label . Bu...
asked by 12.11.2015 / 16:24
1
answer

Result update from another table

I have the following SQL: SELECT id_grade ,MAX(data_lancamento) FROM faturamento_produtos WHERE data_lancamento < '01-01-2010' GROUP BY id_grade Where it does the search only for what was released before 2010. I have another...
asked by 04.03.2016 / 19:25
3
answers

Exchange PostgreSQL connection for MySQL connection

I found a project made in PHP OO to be used in PostgreSQL with this connection file. <?php class BD { public function __construct() { pg_connect("host=localhost port=5432 user=usuario password=senha dbname=nome_do_BD...
asked by 06.09.2015 / 14:33
1
answer

PSYCOPG2 - Paging

In the search for paging using psycopg2 I discovered the attributes cursor.itersize and cursor.arraysize , and the methods cursor.fetchmany () and cursor.scroll () I wanted to check with the staff here if my understanding is correct ab...
asked by 03.02.2016 / 21:51
1
answer

I can not open a byte array extracted from the database!

Language: C # / ASP.NET Database: PostgreeSQL Component used to upload the file: FileUpload The following is the component: Hereisthemethodtoinsertatableinthedatabasethatonlyhasthefields:attachment_id/attachment_name/attachment Andf...
asked by 16.04.2015 / 16:38
1
answer

Doubt with postgres backup?

I have a PostgreSQL 9.0 server on the same machine and also a PostgreSQL 9.4, I have a database on this latest version, when I try to make a backup I have the following error, how could I solve this problem?    C: / Program Files / PostgreSQL...
asked by 19.05.2015 / 04:08
1
answer

How to define the types of columns when doing a copy for PostgreSQL

I'm trying to make a copy for a table I have in Postgre, however it's giving the following error:    ERROR: invalid input syntax for type timestamp: "data_cadastro" I wanted to know how to define this field as timestamp . Follo...
asked by 20.04.2015 / 19:29
1
answer

Search Serial Error Postgresql

Using: c #, windows forms, postgresql I'm having a hard time putting together a routine which writes data to a table and retrieves the id (serial / sequence) and updates the log in another table. Worst of all is that everything works by De...
asked by 28.12.2014 / 14:34
1
answer

Call to undefined function pg_pconnect ()

I need to create a connection with a (already existing) database in PostgreSQL (Installed and working), using this code (which already existed already). File access_bd.php <?php function conecta() { $ip = $_SERVER['SERVER_ADD...
asked by 26.09.2014 / 17:05
2
answers

Using timestamp in different fields

I have a timestamp field in a postgres table. I would like to treat, in delphi, the date in one dbedit and the time in another, is there that possibility ?? In the tests I performed, I can even change the values but when I exit, for example the...
asked by 08.11.2014 / 13:53