The code below is work if But when I drung a lot of file name to textbox It cut some text that over limit how can i fig this problem
Hi Guys,
Can any one please help/assist in best practice or what to look for when working with this database, parameters, configuration, ... etc
thanks in advance.
EL
I am looking to run the Postgres startup service with a non-local user account. We are a Windows environment and our default domain GPO does not permit local users to logon as a service. I w...
GHow can i write sql state ment for 888 then the result must show 78 8 8 5, 458887, rt888u, y8-8-8u,
in postgresql
Hi all,
Need to setup this database first time, as have been working with Oracle & MySql, but for PostgreSQL, this is the first time.
Can any one suggest/guide, what should be the best ...
CREATE OR REPLACE FUNCTION maj_waste_type_in_trash_bag()
RETURNS SETOF trash_bag AS
$BODY$
DECLARE
rec RECORD;
the_waste_type integer;
BEGIN
FOR rec IN (SELECT * FROM trash_bag)
...
Hello,
We are migrating SQL server to Netezza (which used Postgre as base db engine)
We have lot of code which has used datediff() function to find time difference between timestamps in ...
I have a table with email addresses, I want to be able to get a count on all distinct email domains.
I'm using 8.3.7
Thanks
Experts,
How do I install PostgreSQL on Windows Server 2003? I downloaded postgreSQL-8.4.1.1.exe but I do not see where I can create a database. It looks like there is only Serve...
I am recieving the below error when using postgres's embedded sql compiler "ecpg"
sql error No such connection NULL
The application compiles fine and I get the above error only when I run ...
Hi,
I am looking for database management tool for postgresql.
"Must have" function is good database schema comparison tool.
I found http://www.dbsolo.com - SQL Query Tool, it seems to have ...
Hey,
I'm trying to drop all databases before I upgrade postgres from 8.1 to 8.4, but I've been unable to delete the current databases. I'm using dropdb "dbname" but that's not working as...
Hi,
I cant seem to locate the program "R" in Linux i have installed it from the binaries the CRAN Website and i can se the program is installed in package manger but when i go into the term...
Greetings,
I have a postgresql DB and one of the tables get's its primary key from a sequence, and rows are usually inserted from a web application.
But suppose I were to access the DB ...
Hi,,
I'm using the following batch file content to install the postgres:
msiexec /i postgresql-8.2-int.msi /qn INTERNALLAUNCH=1 DOSERVICE=1 DOINITDB=0 ADDLOCAL=server,psql,pgadmin,post...
HI
Please let me know how you convert this script from SQL Server to PostgresSQL since I have been told that Postgres does not support global condition statements (just inside routines)
...
CREATE OR REPLACE FUNCTION maj_waste_type_in_trash_bag() RETURNS SETOF trash_bag AS $$
DECLARE
rec trash_bag%ROWTYPE;
BEGIN
FOR rec IN ( SELECT * FROM trash_bag ) LOOP
...
I need some guidance on how to TRUNCATE all tables in a postgresql database. I used the sql script below but it gave me an error. Please let me know if there is an alternative.
I am looking to query a table full of datetime date of births. I want to basically get a count of everyone in the table who is under 18 years old.
Any help?
Thanks
Hi everyone,
please forgive me for my bad english.
I have a small problem and am trying to solve like almost a week.
I have a table, for example:
id | date | name_id | a |...
I wish to write a query that will return a list of foreign keys and the table to which they pertain.
For example:
- Given a table of 'customers' and a table of 'accounts', in which each cust...
How do I find with which encoding a postgres db was created?
We have a Windows Server running Netvault Backup 8.2.2
the backup client is Freebsd 7.43
The object being backup is a postgresql transaction log.
We're getting this error:
Data Plugin ga...
Hi
I have a postgresssql table of 6 colums
ID, MasterID, Question Text, Q_Date Date , Answer Text, A_Date date
I need to show the user he has a new question & the manager there is an new ...
i have a table in my sql how can I create the same table with postgre sql
I f i use phpmyadmin export to sql state ment then i use sql to run with postgre it will work or not
