Skip to main content
Jonas's user avatar
Jonas's user avatar
Jonas's user avatar
Jonas
  • Member for 13 years, 5 months
  • Last seen more than a week ago
  • Oslo, Norway
1563 votes
9 answers
3.2m views

How do I list all databases and tables using psql?

402 votes
4 answers
934k views

How to insert values into a table from a select query in PostgreSQL?

353 votes
3 answers
222k views

How can I time SQL-queries using psql?

144 votes
3 answers
210k views

How can I specify the position for a new column in PostgreSQL?

135 votes
2 answers
282k views

How do I get the current unix timestamp from PostgreSQL?

116 votes
11 answers
365k views

How to run psql on Mac OS X?

85 votes
10 answers
291k views

How do I use currval() in PostgreSQL to get the last inserted id?

74 votes
3 answers
44k views

What are the drawbacks with using UUID or GUID as a primary key?

58 votes
3 answers
195k views

How to get the timestamp column in only milliseconds from PostgreSQL?

55 votes
5 answers
145k views

How can I use a default value in a Select query in PostgreSQL?

31 votes
1 answer
92k views

How can I convert from Double Precision to Bigint with PostgreSQL?

25 votes
3 answers
126k views

How do I specify that a column should be auto-incremented in pgAdmin?

24 votes
3 answers
59k views

How do I install pgcrypto in PostgreSQL 8.4?

23 votes
6 answers
28k views

Is there any good tool for making Database Design and Prototypes? [closed]

23 votes
1 answer
55k views

How to connect to an remote PostgreSQL database on Ubuntu using pgAdmin3?

21 votes
6 answers
20k views

Are there any good and free tools for managing a PostgreSQL database? [closed]

17 votes
1 answer
115k views

How do I reset the postgres password for PostgreSQL on Windows? [duplicate]

17 votes
6 answers
83k views

How to export an image column to files in SQL Server?

11 votes
2 answers
19k views

How to insert an IP-address into an inet column in PostgreSQL?

9 votes
4 answers
24k views

How can I insert if key not exist with PostgreSQL?

3 votes
1 answer
4k views

How do I install pgcrypto on Windows?

3 votes
1 answer
1k views

Are there any good database management applications for JDBC/Java databases?

2 votes
1 answer
3k views

How can I alter the type of a money-column to decimal in PostgreSQL?

2 votes
1 answer
1k views

Header is added when exporting column of type image with BCP to files

0 votes
2 answers
7k views

How to set lower case for identifiers in Toad?