Top "Postgresql-9.2" questions

How to get a pg_dump -s to include the CREATE DATABASE command?

I have a postgresql db server that has multiple database in it. postgres=# \list List of databases Name | Owner | Encoding | …

postgresql backup postgresql-9.2

PostgresQL: how to start up the database server and create a database

When I try to run a server: postgres@ubuntu:~$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data LOG: …

postgresql-9.2

PostgreSQL create index on cast from string to date

I'm trying to create an index on the cast of a varchar column to date. I'm doing something like this: …

postgresql casting indexing postgresql-9.2

Raise notice to print a table's data

I'd like to be able to print some debug information from sql script / function. Of course, I can do this …

sql postgresql postgresql-9.2

PostgreSQL: How to list all available datatypes?

Question: In PostgreSQL (using SQL, not the console), how can I list all available datataypes ? Ideally like this: http://www.…

sql postgresql postgresql-9.1 postgresql-9.2

psql: FATAL: PAM authentication failed for user

PostgreSQL 9.2.4 I cannot login anymore with a user that has worked in the past. I assume a configuration problem. So …

postgresql postgresql-9.2 pam

alter column from time with time zone to timestamp

I am having trouble changing a column called end_date in a table called key_request from time with time …

sql postgresql timestamp postgresql-9.2 alter

Months between two dates function

In oracle i can find out no:of months between using MONTHS_BETWEEN function. In postgres i am using extract …

function postgresql postgresql-9.1 postgresql-9.2

Select query in row_to_json function

For example , I use the following function to convert rows into json in PostgreSQL 9.2 select row_to_json(row(productid, …

sql json postgresql postgresql-9.2 composite-types

PostgreSQL - properly change ID of table row

How to change id of some table's row? Like: UPDATE table SET id=10 WHERE id=5; But in way that it …

postgresql postgresql-9.2