View Full Version : answers

Pages : [1] 2 3 4 5 6 7 8 9 10 11
  1. Multiple instances of PostgreSQL on the same server?
  2. What is a good approach to PostgreSQL database backups?
  3. pgAdmin, Maintenance - "cannot open the logfile" ?
  4. pg_type
  5. creating a trigger to remote database
  6. plpgsql update cursor where current of with dynamic query
  7. why Postgres inserts null value for parameterized statement?
  8. OpenOffice.org, PostgreSQL and Unicode
  9. oracle to pg
  10. How To Clear The Commands In Postgresql,In Command Line
  11. Help making a multi table query
  12. backup plan for postgresql
  13. Triggers and Domains
  14. Error in psqlodbc configuration
  15. Dropping a tablespace - windows
  16. How can I limit a query to 2 of the same value in one col ordered by another col?
  17. Comparing the same attribute with two different date ranges
  18. Six PostgreSQL questions from a pokerplayer
  19. Insert value to auto increment colomn
  20. PostgreSQL incremental backup & PITR
  21. PGAdmin connection to PostgreSQL
  22. PostgreSQL 8.3.7 installation problem
  23. Help with query
  24. postgre function
  25. Dynamic Fields
  26. Search Postqresql server on the network
  27. script required for installing postgres db on windows
  28. Minimum System Requirement fro PostgreSQL 8.x
  29. About tables
  30. Help for Data Migration
  31. Vacuum
  32. Pseudo-type record seen as column by an older PostgreSQL version
  33. questions about stored procedure
  34. How do I catch the raise output from PL/pgsql in PHP coding
  35. SRF function : missing library on PostgreSQL 8.3.6 on Windows?
  36. Function C and INOUT parameters
  37. ERROR: cross-database references are not implemented
  38. how to subtract month from current date
  39. Logs for PostgreSQL
  40. Remote access from a client on LAN
  41. Triggers in PostgreSQL
  42. Insert records
  43. DB Mirror
  44. DB Server load
  45. Random sample of rows
  46. Query to get total rows in a table in faster way.
  47. Client Encoding in postgresql
  48. Invalid Input Syntax for Type date
  49. Sum of a Sum
  50. Doubt in vacuming and indexing?
  51. Cannot kill Postgresql 8.3 in Windows Xp Service Pack 3
  52. a doubt in database restoring?
  53. How convert array elements to rows?
  54. Convert Oracle outer join query to PostgreSql
  55. Executing function dynamically
  56. PGOLEDB connection from visual basic 6
  57. Database gone a bit wild
  58. Converting PostgreSQL DB to MS-SQL DB
  59. create table MyVariable
  60. Global(shared) variable in postgresql
  61. need some help in function
  62. Installing PostgreSQL on WEPOS
  63. Running function as superuser
  64. PostgreSQL Database backup from a C# application
  65. weekday from timestamp?
  66. Bad date error
  67. day from date
  68. set Locale?
  69. Postgres to Oracle
  70. Dreamweaver CS3 , PostgreSQL and PHP
  71. Is index on column updated if the column is updated but data does not change?
  72. How can i use shared memorry in postgresql using c functions
  73. How to connect to a remote postgresql via http
  74. access or postgree
  75. Database Design
  76. large database
  77. (select Extract(dow...))
  78. Can I know the disfference between postgres restart and reload?
  79. Passing tablename as argument into function
  80. select not using index
  81. connection statement
  82. Problems with empty sets?!
  83. Exception::=>>Object or Provider is not capable of performing requested operation
  84. shared buffer cache monitoring
  85. PostgreSQL to Oracle migration
  86. Postgres "could not write to hash-join temporary file"
  87. Not showing the rows which is having the digits < 6 !!!
  88. ALTER TABLE command?
  89. psqlodbc
  90. Postgres can't talk on TCP/IP connection
  91. How to execute PlPgSql from Command line
  92. Writing a user defined function
  93. database backup to include circular dependencies
  94. Restore data without any backup file
  95. calling functions which are stored as values in a table
  96. Postgres Service start fails
  97. Automatic deleting views of table in PostgreSql
  98. connection to openOffice.org database
  99. checking if the Database exists (by running a batch file)
  100. PostgreSQL object datatype
  101. Triggers in postgres
  102. using a dictionary with Npgsql
  103. Searching across 155 tables
  104. Migrating from Oracle to PostgreSQL
  105. one trigger for two different tables
  106. DB Synchronize
  107. table name as a column datatype
  108. Scalability issues....
  109. Customers of PostgreSQL
  110. how to make this function work....
  111. Execute statement in postgres
  112. Can postgres functions return multiple values???
  113. find the position of character in a string
  114. how to build the source of postgresql 8.3.1 for windows
  115. libpostgres.a
  116. primary key problem on delete
  117. change the datatype of a field
  118. postgres in java
  119. change ownership
  120. a problem of function return setof
  121. Disabling Autocommit
  122. Unable to restore postgres-dump-Version-8.2.4
  123. Transaction Isolation Level
  124. offset, limit problem
  125. max count
  126. connection problem
  127. on a table
  128. postgres server recovery
  129. What is the best free Postgresql frontend available ?
  130. Error restoring bytea from dump
  131. how to add/merge varchar2s(Strings) in PL/SQL
  132. Can anyone help me to writ a function in postgresql
  133. How to writ function in postgres?
  134. 'case column' in HAVING clause
  135. Need help on how to backup a table!!!
  136. Help inserting record to PG with MS Access frontend
  137. ERROR: column "dtype" of relation "xxxxx" does not exist
  138. Inheritance problem
  139. Execute A Psql Commands Through Batch File (*.bat)
  140. How to change character encoding of an existing database
  141. How to close Opened Connections to 'Postgres'?
  142. Size of the database
  143. OdbcDataAdapter Insert Command
  144. What datatype should i use for year?
  145. shapefile database
  146. interface - python - postgresql
  147. Details
  148. Compilation error "Absent rule for target assemble `utf8_and_shift_jis_2004.o'"
  149. PostgreSQL multiple databases
  150. postgre vs MySQL
  151. how to view output of postgreSQL function?
  152. Connection to postgres database failed
  153. Internal Server Error in connecting Postgresql Server
  154. Nonclustered indexes
  155. PHP or PostgreSQL problem?
  156. HELP: Indexes
  157. Postgresql Upgrade from 8.1 to 8.3 on windows
  158. how to run postgresql on debian terminal
  159. Abort transaction due to error
  160. Running two different versions of PostgreSQL
  161. pl/pgsql triggers - Problem with NEW.*
  162. Using Npgsql with .net
  163. changing postgres code
  164. Copy data with several delimiters
  165. How to convert date format in PostgreSQL
  166. Keeping cursors across page reloads/changes
  167. get back deleted data from a table in postgres
  168. AutoBackup Available in PostgreSQL
  169. inserting time into postgres
  170. sample database
  171. regular expressions
  172. plj help
  173. Returning 0, possibly OUTER JOIN???
  174. how to declare the cursors in a stored procedural function
  175. hi
  176. Problem in closing connection in postgresql
  177. export data in excel format
  178. importing into postgreSQL from oracle
  179. Reg Update Local Server to Remote Server
  180. postgreSQL installation problem
  181. database problem
  182. Features And Data Management Strategies Of Postgresql
  183. Not able to drop the database in PostgreSql Server
  184. pg_dump, pg_restore
  185. extracting a month
  186. Issue With COPY TO STDOUT / COPY FROM STDIN
  187. Trigger problem
  188. More Constraints
  189. PostgreSQL connection in CGI-PERL Script
  190. Advanced Constraint
  191. How to read the content of psqldump
  192. Comparison of Open Source databases
  193. How to find duplicate values exists or not
  194. postgreSQL restore problem
  195. Where can I find detailed information about pl/python?
  196. pg_dump: SQL command failed
  197. how-to - trigger function with argument / parameter
  198. user defined data types
  199. transfer tables from postgre to oracle
  200. Connectivity to postgres from asp.net
  201. How to synchronize data from Postgre to cache
  202. Conversion of MySQL spatial query with intermediate tables to PostGre spatial query
  203. SQL server to Postgre
  204. how to transfer datas from oracle to postgre
  205. how to transfer datas from postgre to oracle
  206. Reg Windows Master Linux Slave
  207. Prepared Statement for IN function
  208. i18n support in Postgresql
  209. Postgre subquery help
  210. Rounding Problem in Stored Functions
  211. Input file:permission denied
  212. constraint problem
  213. Relation Does not Exists
  214. Reg Incremental Backup and Restore In Postgres 8.1
  215. to connect PostgreSQL from VB.NET
  216. The "first day" with PostgreSQL and trouble with this
  217. Copy select query result to a file
  218. PostGreSQL Clustering Installation
  219. Postgre with vc++
  220. Sending array from JAVA code to Postgre
  221. indexing, limit problem
  222. Reg Postgres Data Base Server Will Be slow
  223. After OS upgrade from XP to Vista postgre user password does not work
  224. COPY command error
  225. Basic Question - Open Source DBMS
  226. Converting an Access database to Postgresql
  227. Image field in SQL Server 2005 to lo field in PostGres 8.2
  228. database cluster for general user
  229. execution of python function from a postgresql stored procedure
  230. retrieve problem
  231. Relation one-to-one-of
  232. Function returning uple?
  233. How to get password once from user and use that in entire MSDOS batch file.
  234. in postgres sql
  235. when restoring the dump in postgresql 7.3.4, no functions are available
  236. How to enable PITR on all POSTGRES server
  237. Batch file + psql problem
  238. getting started with v 7.4
  239. how to append the string to SQL queries in stored procedure of Postgres....
  240. Creation and modification timestamp
  241. to change datatype
  242. Problem in converting float4 type to float8
  243. postgreSQl chennai trainingc enter
  244. returning columns from different tables, in plpgsql function
  245. Names of columns with foreign keys
  246. Error: relation with OID 22938 does not exist
  247. how to qeuey this in paadmin like mssql
  248. Can you use a stored procedure in a subquery in postgres?
  249. Installation fails
  250. Encoding problem in create database
  251. Address already in Use, postgres doesnot restart
  252. Restoring the dump in a new database does not contain oids
  253. Selection in pgsql using dynamic tables.
  254. Table Creation Problem
  255. Connecting to PostgreSQL using VB.NET
  256. BYTEA convertion to TEXT
  257. PostgreSQL Tablespace Creation Problem
  258. doubt in CASE command
  259. Can I connect to remote DB using psql?
  260. Installation Problems with Windows XP
  261. return type of function wen having different datatypes
  262. round to the nearest integer
  263. Is there a PHP cursor?
  264. Bitemporal tables sequenced unique triggers
  265. postgresql
  266. syntax to view the structure of a table using sql
  267. Running ACT! 2008 Database on two Laptops
  268. getting tuples of result
  269. how to configure Pgpool-II to replicate postgres database in linux
  270. Restore from plain text
  271. Problem in executing sql file
  272. trigger problem
  273. double quotes inside single quotes => ' " ... " '
  274. How to show time stamp in postgres pg_log/TodaysFile
  275. plperl problem
  276. How to setup a Arabic compatable Postgres DB
  277. postgreSQL user permission denied
  278. Postgresql database connection error...
  279. doubt in update query inside a function
  280. CREATE LANGUAGE cannot load library
  281. Need help with a slow UPDATE query
  282. PostgreSQL logical storage
  283. pg_restore in C - language how to...
  284. Physical files
  285. Problem in Select Query
  286. PostgresSQL server connectiong problem with C-language...
  287. Transactions
  288. converting POINT(-43.16 -0.876) to Latitude and Longitude
  289. doubt in exporting a file into database
  290. datamodel
  291. executing a query daily
  292. Error in following query
  293. PG archiver problem
  294. PostgreSQL dump restore from client
  295. Online replication of Postgresql databases
  296. Performance Tuning
  297. Postgresql Reinstallation problem on Windows
  298. problem in using unicode datatype
  299. current transaction is aborted. queries ignored until end of the transaction block
  300. Problem regarding a function
  301. install postgre
  302. install postgre
  303. why did not suppert Rollback? postgresql
  304. doubts in slony
  305. difference
  306. PostScript Reports
  307. stupid misstake with DB encoding
  308. Query about 20,000 record problem(slow)
  309. Problems with unique key constraint.(CASE INSENSITIVE)
  310. Insert data in win1251 encoding to base with utf8 encoding
  311. Problem inserting into a view
  312. Updating a coloumn value by comparing coloumns from two tables
  313. Top Value in a Table
  314. PostgreSQL equivalent to MySQL LOCATE()
  315. pg_dump backup doesnt restore everything - things missing... restore howto required
  316. Using the result of a function that RETURNS SETOF
  317. Closing a database
  318. doubt regarding rollback
  319. database connection problem
  320. logically-delete a row rather than actually remove in from table in postgreSQL
  321. Restore after server crash
  322. Add not null column in a table
  323. Rules in Postgresql
  324. FATAL: role "root" does not exist
  325. postres triggers
  326. Problem: Retrieving Records based on the From & To Date
  327. doubt in arrays used in function
  328. PostgreSql Documents
  329. how to move the data ,because of the partition table
  330. doubt in function
  331. MySQL and PostgreSQL
  332. Reading into FoxPro via psqlODBC
  333. how can we use partition table ?
  334. Combining two fields data into one field in the same table
  335. Need Help In Postgres
  336. COPY Query fails in postgre release 8.2
  337. how can i use the initdb?
  338. Optimal architecture for a postgres DB?
  339. Open Source Application Server (PostgreSQL Perspective)
  340. function in postgreSql
  341. How to speed up a query
  342. Cannot change column data type
  343. query the results of a table function applied to all the rows of a different table
  344. Project On Postgresql
  345. features and data management strategies of PostgreSQL
  346. Duplicate a DB
  347. how to retrieve number of fields in the table
  348. Installation Issues
  349. Lock Problem
  350. How to create Function for executing query ....
  351. DISTINCT or GROUP BY don't seem to help
  352. Multiple Group by
  353. ERROR : relation "master"
  354. Error while running createdb from a batch file in windows xp
  355. Are queries different between sql and postgresql?
  356. Integer array in where clause
  357. copy command
  358. Partitioning database in Postgres
  359. how to get column names of a table
  360. copy command
  361. Using cursor for update
  362. Enterprise Wide Deployment
  363. syntax for copy command
  364. Benchmarking tools for PostgreSQL on Linux (fedora)
  365. ERROR: return type mismatch in function returning tuple
  366. ERROR: SELECT query has no destination for result data;
  367. inserting data in time field
  368. Get the generated value of serial type field (primary key)
  369. Slony-I questions
  370. Select For Update
  371. Function To Return Insert Statements In Postgres
  372. Extract date from timestamp
  373. Exporting data from postgresql to oracle
  374. Is there separate package for client and server in postgresql
  375. Server - Client Application
  376. doubt in a datatype
  377. syntax to view the structure of a table
  378. Is Pg replication used for multi master or two master asynnchronus replication
  379. explain
  380. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  381. Cant view table description
  382. PGCluster-II version 1.3 implementation
  383. Error:: 'more' is not recognized as an internal or external command
  384. What replication are people using
  385. Import data into Postgresql
  386. how to post to the forum
  387. Understanding End of Cursor?
  388. A far cry - but here's hoping - PostgreSQL Replicator
  389. Too many clients already
  390. Installation of PostgreSQL on Windows XP
  391. Help with Tags database design.
  392. retrieve two tables in a single query
  393. Returning SETOF in plpgsql
  394. oid problem
  395. How to add a column to the table
  396. Convert data from char type to byte tape
  397. Stored functions
  398. Mapping select results through a function
  399. Stored functions books
  400. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  401. alias name inside the function
  402. What is the output statement in PostgreSQL
  403. Regarding Installation of postgresql as a client - server
  404. syntax error at or near "TYPE"
  405. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  406. Hybrid Environment
  407. Too Many Client Connections -- Error -- Need Help
  408. Hello everyone, I am new to this site and SQL server
  409. Building an aggregate function
  410. "is not scalar Variable" Error
  411. scripts for converting dbf or mdb files to postgres
  412. array parameter in plpgsql function
  413. Keeping two db's in synch across continents
  414. order by for varchar datatype column with numeric values
  415. Functiion Problem
  416. starting psql in windows
  417. Postgres backup and restore
  418. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  419. shp2pgsql Help with syntax
  420. pg_restore is not recognizing dump
  421. maximum function
  422. What is commit_delay & commit_siblings?
  423. Problem with function
  424. Start of Year
  425. migration tool
  426. All About - PostgreSql
  427. PostgreSQL and OleDb
  428. Need help with triggers
  429. using ILIKE xyz where xyz is a function parameter
  430. Pgsql 8.4 on Vista starts and stops automatically.
  431. bulk copy from flat file to postgres dbserver
  432. output parameters in functions
  433. Postgres 7.x and Legato backup
  434. Postgres8.1 Database Server could not be started
  435. How to store binary files in the PostgreSql database table?
  436. How PostgreSQL searching Queries?
  437. Constraints vs Indexes
  438. Create function question...
  439. Transaction Problem
  440. Improving date(timestamp) searches
  441. crystal report
  442. How to set TG_ARGV values
  443. USE OF VARIABLES IN postgreSQL
  444. How to replace characters in dblink
  445. getting latest filled row
  446. problem with date
  447. How to get column name
  448. Auto mail sending using postgresql
  449. syntax is not supported error
  450. need an sql query for the following situation
  451. Copy Table to other database
  452. Cannot compile plpgsql function
  453. pg_dump Failure
  454. Aggregate/concatenate function (flattening columns into a row)
  455. Temporary tables
  456. User and Role
  457. How to copy data from one table to other table
  458. Function declaration for MSFTSql developer
  459. function execution
  460. using array data type
  461. What would my SQL statement look like?
  462. Database connection problem
  463. Error Installing PostgreSQL 8.1.9 on XP
  464. no lock
  465. unsorted column
  466. how to convert a query from SQL to HQL(hibernate Query Language)
  467. Beginning with PostgreSQL
  468. How to configure static ip PostgresSQL 8.1 for windows XP system
  469. How to find out that SSL is activated
  470. Postgresql 8.2 connection problem on static ip
  471. Stored Procedures in PostgreSQL
  472. execute funtions in psql
  473. SUM with possible NULL values
  474. Connecting to PostgreSQL through SSH (putty)
  475. Exporting tables from Postgres to SQL
  476. Installation of PostgreSQL 8.0 on Solaris10
  477. Stored procedure
  478. problem in querry
  479. Adding new column to existing table
  480. Support for ROWNUM and ROWID
  481. Size of table and size of database
  482. Use Of Dblink
  483. how to export postgresql tables
  484. psql won't connect, though other clients are OK
  485. Serverless/embedded PostgreSQL database
  486. Date difference
  487. count months between two dates
  488. 24 hour time format
  489. Substract hour into a function
  490. import Excel to postgreSQL
  491. Retrieve number of rows in table
  492. Invoking psql at command prompt
  493. Migration from SQL Server to PostgreSQL
  494. How to recover the deleted fields with values from bakup.
  495. recovering fields in tables
  496. Postgres Violates Primary key and OID
  497. hai i am new here.i have question,please give me reply as soon as possible
  498. Function returning setof
  499. PostreSql function
  500. Migrating IBM Universe Database to Postgres, date format Problem
  501. Run Unix Shell Scripts With Postgres Trigger
  502. server closed the connection unexpectedly
  503. getting current date
  504. For Report Generate
  505. Usisng PQgetvalue
  506. Database Design Help
  507. Need help with query involving automatically decaying values
  508. psql copy
  509. Getting Parse Error at or near and at character......
  510. Variable column name
  511. Transfer of Data from Oracle to PostgreSQL
  512. create database if not exists
  513. data fetch and insert
  514. Oid
  515. Foreign key problem
  516. How to assign a primary key
  517. pg_restore doesn't work for postgresql 7.2.3
  518. How To Execue Queris Fastly
  519. Posting Guidelines. Please read before you post in a forum!
  520. Inheritance Problem
  521. Help : what this Error means
  522. Installing PostgreSQL 8.1 on VISTA
  523. load balancing
  524. how retrive this problem
  525. Problem in function with CREATE ROLE with parameters
  526. BackUp and Restore PostGreSQL8.1
  527. HOW TO exit from a query
  528. controlling postgres I/O and CPU processing
  529. performance tuning postgres 8.2.3 on windows with shared server applications
  530. Retrieving values from tables
  531. stored procedure in postgresql
  532. Problem with Windows PostgreSQL 8.1 service
  533. download old version of PG
  534. restore problem
  535. how to compare two tables
  536. what is the keyWord DELETING
  537. Strange result using transactions
  538. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  539. Postgresql installation problem??
  540. php objects in postgresql
  541. odbc call failed
  542. Starting More Than one Transaction
  543. Fatal error: Call to undefined function pg_connect()
  544. Connection Exception
  545. joins
  546. How to know the Number of Connection made with the database
  547. how to write the select query for this situation
  548. C# .NET ===> postgreSQL
  549. Pagination in Postgre
  550. If criteria is Null then show all.