for PostgreSQL questions specific to version 9.2.
I have column arr which is of type array. I need to get rows, where arr column contains value s …
postgresql postgresql-9.2I'm using PostgreSql version : postgres=# select version(); version ------------------------------------------------------------- PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit (1 row) i had connected …
postgresql postgresql-9.1 postgresql-9.2In PostgreSql 9.2.4 I have two tables: user (id, login, password, name) and dealer (id, user_id). And I want to …
sql postgresql insert postgresql-9.2I have a column added_at of type timestamp without time zone. I want it's default value to be the …
postgresql timestamp postgresql-9.2I am using Ubuntu 12.04 and Postgress 9.2. I need to create this user with this password e.g. postgres://admin:[email protected]:5432 …
postgresql ubuntu postgresql-9.2Hi I am using postgresql 9.2 and I want to use varchar(n) to store some long string but I don't …
sql postgresql-9.2I'm trying to map the results of a query to JSON using the row_to_json() function that was added …
json postgresql postgresql-9.2 scalar-subqueryI am trying to query a database table in postgresql, but every time I run the below query it gives …
sql database postgresql-9.2CREATE TABLE app_for_leave ( sno integer NOT NULL, eid integer, ename varchar(20), sd date, ed date, sid integer, status …
sql postgresql postgresql-9.2I have a TEXT column containing valid JSON string. CREATE TABLE users(settings TEXT); INSERT INTO users VALUES ('{"language":"…
postgresql postgresql-9.2