What is the difference between to_tsvector() and ::tsvector ?

What is the storage size of an integer on a 64bit system?

While creating a trigger, the function it will call may be created after it and attached to it.

Which function should be used to highlight the results?

Which PostgreSQL version added the enum datatype?

When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?

Are the contents of the pg_autovacuum system catalog saved when pg_dumpall is used to backup the database?

Which PostgreSQL version added the enum datatype?

How will you list the available functions from psql?

In the following list, which operators do a case insensitive string matching?

Which of the following queries will create a table with two fields, 'id' and 'name' with 'id' as an auto incrementing primary key?