Frequently Asked Questions relating PostgreSQL database
How do I use a command line PostgreSQL client without SSH access?
psql -h pgsql.yourdomainname -U dbusername dbname_domain_com
NOTE: "dbusername" and "dbname_domain_com" should be replaced with the actual values for your database name and database username.
I want to increase length of a column field.
1. Create a new column with the correct length.
2. Copy the data from the old column to the new column.
3. Rename the old column to something other.
4. Rename the new column to the old column's name.
5(optional). Reset the auto-increment counter of the new column to match the old column, if one exists in the old column.
Postgres does not have a quick way of changing a column type at the moment.
What is the maximum number of simultaneous connections to the database?
10 simultaneous script connections are permitted. Please be aware that due to this, your scripts must close all open connections once the data you require has been retrieved.
|
