[SQL] Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)

2012-07-10 Thread Chris Preston
Hello all, How far can I get to a higher version of PostgreSQL by just entering a command line instruction to upgrade without any major effort? Regards Chris Preston -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[SQL] Updating Query of 1 table from data in another

2008-10-13 Thread Chris Preston
Hello all, I'm still new to postgres If I have 2 tables with the following data structure Agentno and agentname (along with many other fields) this table is called agent_master And I have another table with agentno and agentname. Table called updatetable When I add data in the updateta

[SQL] Encrytion in postgres field in table

2008-07-28 Thread Chris Preston
How do I setup a password table that I only want to encrypt 1 field "password"

[SQL] Converting Copy to insert statement in backup file

2008-07-10 Thread Chris Preston
Hello, I have a backup cron job (shown below) but its too big and there are times that I want to just cut out from the text file certain areas to restore data in a specific table. Looking in the file, I notice there is a "copy" command.. Someone told me that there was a parameter that I could use

[SQL] Cross Tab Functions

2008-06-20 Thread Chris Preston
Hello All, I have used the cross tab function to setup tables that display months' data, however i need to display years data instead of the months.. so i would display 2006 as a column, 2007 as a colum and 2008 as a column. when i tried to modify the simple example of the cross tab (shown below)

[SQL] crosstab functions in postgres 8.1

2008-06-06 Thread Chris Preston
Hello, I am almost a newbie to postgres and only recently found out about one of the greatest function crosstab in postgres. The problem is that I am using 8.1 and when I run the function I am getting an error relating to $libdir/tablefunc.. someone mentioned that it might be because I am usin