postgresql-9.3 Questions
3
Solved
The idea is that I have local database named northwind, and with postgres_fdw I want to connect with another database named test on localhost (remote connection simulation, for situations like when...
Culdesac asked 27/4, 2015 at 16:6
3
Solved
I have a sequence on postgresql 9.3 inside a schema.
I can do this:
SELECT last_value, increment_by from foo."SQ_ID";`
last_value | increment_by
------------+--------------
1 | 1 (1 fil...
Emmy asked 28/1, 2014 at 5:30
16
I'm using this SQL query to generate random value in PostgreSQL
chr(ascii('B') + (random() * 25)::integer)
How I can generate 15 characters random String using the same query?
Machiavelli asked 10/4, 2016 at 17:58
2
Solved
I have column 'event_date_time' in my 'events' table with type 'timestamp with timezone'. My python flask application is saving date like '2014-08-30 02:17:02+00:00' but postgres automatically conv...
Bangs asked 22/8, 2014 at 22:31
5
I have installed PostgreSQL 9.3 on my pc. When I try to start the database by pgAdminIII, I am getting the error below.
Error connecting to server : received invalid response to SSL negotiation
...
Pulsifer asked 4/2, 2015 at 5:3
16
Solved
How can I list all the tables of a PostgreSQL database and order them by size?
Marque asked 12/2, 2014 at 20:2
5
Solved
I have a scenario where I need to convert a json array into a Postgres int array and query it for the result. Below is my array
ID DATA
1 {"bookIds" : [1,2,3,5], "storeIds": [...
Hylotheism asked 7/6, 2016 at 17:57
3
Solved
Using django 1.8 + Postgres 9+, I have models with custom PG datatypes (like ltree). Creating de database from zero fail because
CREATE EXTENSION ltree;
is not executed. I try with a empty migr...
Brigittebriley asked 16/9, 2015 at 21:29
3
Solved
I have Java 8 Spring web app that will support multiple regions. I need to make calendar events for a customer location. So let's say my web and Postgres server is hosted in MST timezone (but I gue...
Ypsilanti asked 5/4, 2016 at 4:46
3
Solved
I want to index data in height dimensions (128 dimensional vectors of integers in range of [0,254] are possible):
| id | vector |
| 1 | { 1, 0, ..., 254} |
| 2 | { 2, 128, ...,1} |
| . | { 1, 0, ....
Mariammarian asked 15/2, 2016 at 9:2
6
Solved
I try to copy the content of a CSV file into my postgresql db and I get this error "extra data after last expected column".
The content of my CSV is
agency_id,agency_name,agency_url,agency_time...
Piddling asked 2/11, 2014 at 16:41
9
Solved
I have a table to store information about my rabbits. It looks like this:
create table rabbits (rabbit_id bigserial primary key, info json not null);
insert into rabbits (info) values
('{"name":"...
Teran asked 12/11, 2013 at 9:40
4
using Postgres 9.3...
Can someone please explain why I can't use a max function directly on an unnested array..?
It is my understanding the unnest function returns a "setof" just like the select ...
Margaux asked 5/2, 2015 at 18:23
2
Solved
I'm using PostgreSQL 9.3 version to create database.
I have the following table test with some columns list.
create table test
(
cola varchar(10),
colb varchar(10),
colc varchar(10),
cold var...
Stealthy asked 16/1, 2015 at 6:3
7
I want a shortcut key to clear the screen in my (Windows 7) psql console just like CTRL-l clears the screen in my R console. I am tired of typing '! cls'. Do I need to write a macro for this? I am ...
Lopez asked 26/9, 2014 at 17:47
2
Trying to execute SQL script in Pycharm using button "Execute SQL script" and get:
Error executing SQL script
"/home/mike/PycharmProjects/db_pjct/DB/f_companies.sql". Details:
Cannot run progr...
Anaheim asked 14/1, 2017 at 10:50
3
Solved
My problem: I'm trying to run a database generation script at the command line via a batch file as part of a TFS build process to enable nightly testing on a known dataset.
The scripts we run are...
Ramadan asked 18/2, 2016 at 13:8
1
I have a database that needs backing up, but only for specific timestamps and tables, like from the first of October to the 15th of October. After looking up on multiple sites, I have not found any...
Glossolalia asked 2/11, 2021 at 10:1
3
Solved
I want to be able to query settings in another existing session. In particular the transaction_isolation. We have:
current_setting('transaction_isolation')
I want to call something like:
sessio...
Cuxhaven asked 27/1, 2015 at 16:34
4
Solved
Is there some way to test an unassigned record for null? (Sorry, sqlfiddle doesn't like my DO block.) Thanks.
DO
$$
DECLARE
r record;
BEGIN
r := null;
if r is null -- ERROR: record "r" is not as...
Pilchard asked 11/6, 2015 at 16:24
3
I have gone through many SO question answer my problem was not solved..
This is the method I tried:
user@user-Latitude-XT3:~$ sudo su postgres
No passwd entry for user 'postgres'
user@user-Latit...
Carmarthenshire asked 10/9, 2017 at 15:27
2
Solved
Does PostgreSQL cache execution plan of a view, as it does for stored procedures?
Illicit asked 16/9, 2014 at 9:14
22
When I try to run the command:
import psycopg2
I get the error:
ImportError: dlopen(/Users/gwulfs/anaconda/lib/python2.7/site-packages/psycopg2/_psycopg.so, 2): Library not loaded: libssl.1.0.0...
Abessive asked 3/12, 2014 at 5:49
3
Solved
Using PostgreSQL 9.3.
Have a column with file name values like that:
qwerty.swf
some.image.jpg
some.other.image.jpg
This column also allow null values.
How to get file extensions from this c...
Towney asked 29/6, 2016 at 14:39
3
Solved
I am trying to get statistics on indexes. I am looking for total values in an index and it size.
I can only find the size of all indexes on the table.
Table pg_class column relpages and reltuples s...
Pucker asked 28/9, 2017 at 13:10
1 Next >
© 2022 - 2024 — McMap. All rights reserved.