Questions tagged as 'postgresql'

Tagged questions
1
answer

what is the limit of an id, in database?

I have a database in Postgres that is already running a week and the amount of data entered is 3788, this number reflects the id of my table, plus I am informed that this amount is similinar per week. I create the id in t...
asked by 01.04.2018 / 00:54
1
answer

Use character? in sql queries using codeigniter

I have the following SQL query and I want to use the character "?" because the postgres 9.5 syntax requires it, the problem is that codeigniter by default uses that symbol to replace values in the SQL query. Any recommendations? SELE...
asked by 18.09.2018 / 02:36
4
answers

connection c # with postgres

I have a problem with this connection to pgsql. I do not know what is happening. I placed a breakpoint in each line of code and it enters all the lines but the user does not recognize me, I do not know if I'm doing it wrong or I'm missing someth...
asked by 04.04.2016 / 20:03
1
answer

Group by week - day that starts the week

The scenario is that I have some events a day, and I have to group them per week, in such a way that they can be agurped such that: SELECT array_agg(a_day) as data, week FROM ( SELECT day::date as a_day, date_trunc('week', day) :: date...
asked by 29.11.2018 / 14:25
1
answer

Multiple filtering Django Rest Framework

I wanted to do a multiple filtering by url with the API Django Rest Framework that is to say that for example type www.domain.com/clientes/Nike/ES and return me all Nike customers from Spain, the thing is that I do not know how to cross the...
asked by 19.05.2016 / 11:02
2
answers

Retrieve total of items from combinations

I have the following table in a PostgreSQL database: CREATE TABLE combinaciones ( id serial NOT NULL, valor character varying NOT NULL, CONSTRAINT id_pk PRIMARY KEY (id) ) WITH (OIDS=FALSE); ALTER TABLE combinaciones OWNER TO post...
asked by 13.06.2018 / 02:04
3
answers

How to connect to the database with postgresql using php?

$dbservername = "localhost"; $dbusername = "postgres"; $dbname = "asistencia"; $dbpassword = "123456"; $puerto = "5432"; $con=pg_connect("host=localhost, dbname=asistencia, user=postgres, $dbname, $dbpassword"); I have previously connected...
asked by 27.07.2018 / 16:08
3
answers

Can I use MySQL Server and PostgreSQL at the same time without port conflicts or other problems?

Sorry to ask you this but I have hardly any knowledge on this subject. I'm doing a project on Spring Roo and gvNIX using IDE Eclipse. I have seen tutorials that use Postgre SQL to do certain actions and examples how to use GEO components, I n...
asked by 09.05.2016 / 18:12
3
answers

Get the names of the tables of a BD in postgresql

I am doing a script to audit the tables of a postgres database, for which I need to obtain the names of the tables that are in the database and in this way I can go through them through an array, since the Database has many tables and I do not w...
asked by 16.06.2017 / 18:25
2
answers

Create database and tables from java

I am developing a SaaS and I am in the database part, what I want to do is create a database in postgresql for each client that registers but I do not know how to create them from java since the code that I have is the next: CREATE DATABASE "I...
asked by 20.12.2016 / 16:27