postgresql Archives - Page 7 of 21

I am looking for some docs and/or examples for the new JSON functions in PostgreSQL 9.2. Specifically, given a series of JSON records: ...

I need to take the first N rows for each group, ordered by custom column. Given the following table: db=# SELECT * FROM ...

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work ...

How do I get datatype of specific field from table in postgres ? For example I have the following table, student_details ( stu_id ...

I am switching to PostgreSQL from SQLite for a typical Rails application. The problem is that running specs became slow with PG. On ...

Is this proper postgresql syntax to add a column to a table with a default value of false ALTER TABLE users ADD "priv_user" ...

I have a bunch of rows that I need to insert into table, but these inserts are always done in batches. So I ...

Is there any query available to list all tables in my Postgres DB. I tried out one query like: SELECT table_name FROM information_schema.tables ...

Is email address a bad candidate for primary when compared to auto incrementing numbers? Our web application needs the email address to be ...