View Full Version : postgresql answers


Pages : 1 [2] 3 4 5 6 7 8 9 10 11

  1. SQL server to Postgre
  2. how to transfer datas from oracle to postgre
  3. how to transfer datas from postgre to oracle
  4. Reg Windows Master Linux Slave
  5. Prepared Statement for IN function
  6. i18n support in Postgresql
  7. Postgre subquery help
  8. Rounding Problem in Stored Functions
  9. Input file:permission denied
  10. constraint problem
  11. Relation Does not Exists
  12. Reg Incremental Backup and Restore In Postgres 8.1
  13. to connect PostgreSQL from VB.NET
  14. The "first day" with PostgreSQL and trouble with this
  15. Copy select query result to a file
  16. PostGreSQL Clustering Installation
  17. Postgre with vc++
  18. Sending array from JAVA code to Postgre
  19. indexing, limit problem
  20. Reg Postgres Data Base Server Will Be slow
  21. After OS upgrade from XP to Vista postgre user password does not work
  22. COPY command error
  23. Basic Question - Open Source DBMS
  24. Converting an Access database to Postgresql
  25. Image field in SQL Server 2005 to lo field in PostGres 8.2
  26. database cluster for general user
  27. execution of python function from a postgresql stored procedure
  28. retrieve problem
  29. Relation one-to-one-of
  30. Function returning uple?
  31. How to get password once from user and use that in entire MSDOS batch file.
  32. in postgres sql
  33. when restoring the dump in postgresql 7.3.4, no functions are available
  34. How to enable PITR on all POSTGRES server
  35. Batch file + psql problem
  36. getting started with v 7.4
  37. how to append the string to SQL queries in stored procedure of Postgres....
  38. Creation and modification timestamp
  39. to change datatype
  40. Problem in converting float4 type to float8
  41. postgreSQl chennai trainingc enter
  42. returning columns from different tables, in plpgsql function
  43. Names of columns with foreign keys
  44. Error: relation with OID 22938 does not exist
  45. how to qeuey this in paadmin like mssql
  46. Can you use a stored procedure in a subquery in postgres?
  47. Installation fails
  48. Encoding problem in create database
  49. Address already in Use, postgres doesnot restart
  50. Restoring the dump in a new database does not contain oids
  51. Selection in pgsql using dynamic tables.
  52. Table Creation Problem
  53. Connecting to PostgreSQL using VB.NET
  54. BYTEA convertion to TEXT
  55. PostgreSQL Tablespace Creation Problem
  56. doubt in CASE command
  57. Can I connect to remote DB using psql?
  58. Installation Problems with Windows XP
  59. return type of function wen having different datatypes
  60. round to the nearest integer
  61. Is there a PHP cursor?
  62. Bitemporal tables sequenced unique triggers
  63. postgresql
  64. syntax to view the structure of a table using sql
  65. Running ACT! 2008 Database on two Laptops
  66. getting tuples of result
  67. how to configure Pgpool-II to replicate postgres database in linux
  68. Restore from plain text
  69. Problem in executing sql file
  70. trigger problem
  71. double quotes inside single quotes => ' " ... " '
  72. How to show time stamp in postgres pg_log/TodaysFile
  73. plperl problem
  74. How to setup a Arabic compatable Postgres DB
  75. postgreSQL user permission denied
  76. Postgresql database connection error...
  77. doubt in update query inside a function
  78. CREATE LANGUAGE cannot load library
  79. Need help with a slow UPDATE query
  80. PostgreSQL logical storage
  81. pg_restore in C - language how to...
  82. Physical files
  83. Problem in Select Query
  84. PostgresSQL server connectiong problem with C-language...
  85. Transactions
  86. converting POINT(-43.16 -0.876) to Latitude and Longitude
  87. doubt in exporting a file into database
  88. datamodel
  89. executing a query daily
  90. Error in following query
  91. PG archiver problem
  92. PostgreSQL dump restore from client
  93. Online replication of Postgresql databases
  94. Performance Tuning
  95. Postgresql Reinstallation problem on Windows
  96. problem in using unicode datatype
  97. current transaction is aborted. queries ignored until end of the transaction block
  98. Problem regarding a function
  99. install postgre
  100. install postgre
  101. why did not suppert Rollback? postgresql
  102. doubts in slony
  103. difference
  104. PostScript Reports
  105. stupid misstake with DB encoding
  106. Query about 20,000 record problem(slow)
  107. Problems with unique key constraint.(CASE INSENSITIVE)
  108. Insert data in win1251 encoding to base with utf8 encoding
  109. Problem inserting into a view
  110. Updating a coloumn value by comparing coloumns from two tables
  111. Top Value in a Table
  112. PostgreSQL equivalent to MySQL LOCATE()
  113. pg_dump backup doesnt restore everything - things missing... restore howto required
  114. Using the result of a function that RETURNS SETOF
  115. Closing a database
  116. doubt regarding rollback
  117. database connection problem
  118. logically-delete a row rather than actually remove in from table in postgreSQL
  119. Restore after server crash
  120. Add not null column in a table
  121. Rules in Postgresql
  122. FATAL: role "root" does not exist
  123. postres triggers
  124. Problem: Retrieving Records based on the From & To Date
  125. doubt in arrays used in function
  126. PostgreSql Documents
  127. how to move the data ,because of the partition table
  128. doubt in function
  129. MySQL and PostgreSQL
  130. Reading into FoxPro via psqlODBC
  131. how can we use partition table ?
  132. Combining two fields data into one field in the same table
  133. Need Help In Postgres
  134. COPY Query fails in postgre release 8.2
  135. how can i use the initdb?
  136. Optimal architecture for a postgres DB?
  137. Open Source Application Server (PostgreSQL Perspective)
  138. function in postgreSql
  139. How to speed up a query
  140. Cannot change column data type
  141. query the results of a table function applied to all the rows of a different table
  142. Project On Postgresql
  143. Duplicate a DB
  144. how to retrieve number of fields in the table
  145. Installation Issues
  146. Lock Problem
  147. How to create Function for executing query ....
  148. DISTINCT or GROUP BY don't seem to help
  149. Multiple Group by
  150. ERROR : relation "master"
  151. Error while running createdb from a batch file in windows xp
  152. Are queries different between sql and postgresql?
  153. Integer array in where clause
  154. copy command
  155. Partitioning database in Postgres
  156. how to get column names of a table
  157. copy command
  158. Using cursor for update
  159. Enterprise Wide Deployment
  160. syntax for copy command
  161. Benchmarking tools for PostgreSQL on Linux (fedora)
  162. ERROR: return type mismatch in function returning tuple
  163. ERROR: SELECT query has no destination for result data;
  164. inserting data in time field
  165. Get the generated value of serial type field (primary key)
  166. Slony-I questions
  167. Select For Update
  168. Function To Return Insert Statements In Postgres
  169. Extract date from timestamp
  170. Exporting data from postgresql to oracle
  171. Is there separate package for client and server in postgresql
  172. Server - Client Application
  173. doubt in a datatype
  174. syntax to view the structure of a table
  175. Is Pg replication used for multi master or two master asynnchronus replication
  176. explain
  177. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  178. Cant view table description
  179. PGCluster-II version 1.3 implementation
  180. Error:: 'more' is not recognized as an internal or external command
  181. What replication are people using
  182. Import data into Postgresql
  183. how to post to the forum
  184. Understanding End of Cursor?
  185. A far cry - but here's hoping - PostgreSQL Replicator
  186. Too many clients already
  187. Installation of PostgreSQL on Windows XP
  188. Help with Tags database design.
  189. retrieve two tables in a single query
  190. Returning SETOF in plpgsql
  191. oid problem
  192. How to add a column to the table
  193. Convert data from char type to byte tape
  194. Stored functions
  195. Mapping select results through a function
  196. Stored functions books
  197. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  198. alias name inside the function
  199. What is the output statement in PostgreSQL
  200. Regarding Installation of postgresql as a client - server
  201. syntax error at or near "TYPE"
  202. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  203. Hybrid Environment
  204. Too Many Client Connections -- Error -- Need Help
  205. Hello everyone, I am new to this site and SQL server
  206. Building an aggregate function
  207. "is not scalar Variable" Error
  208. scripts for converting dbf or mdb files to postgres
  209. array parameter in plpgsql function
  210. Keeping two db's in synch across continents
  211. order by for varchar datatype column with numeric values
  212. Functiion Problem
  213. starting psql in windows
  214. Postgres backup and restore
  215. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  216. shp2pgsql Help with syntax
  217. pg_restore is not recognizing dump
  218. maximum function
  219. What is commit_delay & commit_siblings?
  220. Problem with function
  221. Start of Year
  222. migration tool
  223. All About - PostgreSql
  224. PostgreSQL and OleDb
  225. Need help with triggers
  226. using ILIKE xyz where xyz is a function parameter
  227. Pgsql 8.4 on Vista starts and stops automatically.
  228. bulk copy from flat file to postgres dbserver
  229. output parameters in functions
  230. Postgres 7.x and Legato backup
  231. Postgres8.1 Database Server could not be started
  232. How to store binary files in the PostgreSql database table?
  233. How PostgreSQL searching Queries?
  234. Constraints vs Indexes
  235. Create function question...
  236. Transaction Problem
  237. Improving date(timestamp) searches
  238. crystal report
  239. How to set TG_ARGV values
  240. USE OF VARIABLES IN postgreSQL
  241. How to replace characters in dblink
  242. getting latest filled row
  243. problem with date
  244. How to get column name
  245. Auto mail sending using postgresql
  246. syntax is not supported error
  247. need an sql query for the following situation
  248. Copy Table to other database
  249. Cannot compile plpgsql function
  250. pg_dump Failure
  251. Aggregate/concatenate function (flattening columns into a row)
  252. Temporary tables
  253. User and Role
  254. How to copy data from one table to other table
  255. Function declaration for MSFTSql developer
  256. function execution
  257. using array data type
  258. What would my SQL statement look like?
  259. Database connection problem
  260. Error Installing PostgreSQL 8.1.9 on XP
  261. no lock
  262. unsorted column
  263. how to convert a query from SQL to HQL(hibernate Query Language)
  264. Beginning with PostgreSQL
  265. How to configure static ip PostgresSQL 8.1 for windows XP system
  266. How to find out that SSL is activated
  267. Postgresql 8.2 connection problem on static ip
  268. Stored Procedures in PostgreSQL
  269. execute funtions in psql
  270. SUM with possible NULL values
  271. Connecting to PostgreSQL through SSH (putty)
  272. Exporting tables from Postgres to SQL
  273. Installation of PostgreSQL 8.0 on Solaris10
  274. Stored procedure
  275. problem in querry
  276. Adding new column to existing table
  277. Support for ROWNUM and ROWID
  278. Size of table and size of database
  279. Use Of Dblink
  280. how to export postgresql tables
  281. psql won't connect, though other clients are OK
  282. Serverless/embedded PostgreSQL database
  283. Date difference
  284. count months between two dates
  285. 24 hour time format
  286. Substract hour into a function
  287. import Excel to postgreSQL
  288. Retrieve number of rows in table
  289. Invoking psql at command prompt
  290. Migration from SQL Server to PostgreSQL
  291. How to recover the deleted fields with values from bakup.
  292. recovering fields in tables
  293. Postgres Violates Primary key and OID
  294. hai i am new here.i have question,please give me reply as soon as possible
  295. Function returning setof
  296. PostreSql function
  297. Migrating IBM Universe Database to Postgres, date format Problem
  298. Run Unix Shell Scripts With Postgres Trigger
  299. server closed the connection unexpectedly
  300. getting current date
  301. For Report Generate
  302. Usisng PQgetvalue
  303. Database Design Help
  304. Need help with query involving automatically decaying values
  305. psql copy
  306. Getting Parse Error at or near and at character......
  307. Variable column name
  308. Transfer of Data from Oracle to PostgreSQL
  309. create database if not exists
  310. data fetch and insert
  311. Oid
  312. Foreign key problem
  313. How to assign a primary key
  314. pg_restore doesn't work for postgresql 7.2.3
  315. How To Execue Queris Fastly
  316. Posting Guidelines. Please read before you post in a forum!
  317. Inheritance Problem
  318. Help : what this Error means
  319. Installing PostgreSQL 8.1 on VISTA
  320. load balancing
  321. how retrive this problem
  322. Problem in function with CREATE ROLE with parameters
  323. BackUp and Restore PostGreSQL8.1
  324. HOW TO exit from a query
  325. controlling postgres I/O and CPU processing
  326. performance tuning postgres 8.2.3 on windows with shared server applications
  327. Retrieving values from tables
  328. stored procedure in postgresql
  329. Problem with Windows PostgreSQL 8.1 service
  330. download old version of PG
  331. restore problem
  332. how to compare two tables
  333. what is the keyWord DELETING
  334. Strange result using transactions
  335. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  336. Postgresql installation problem??
  337. php objects in postgresql
  338. odbc call failed
  339. Starting More Than one Transaction
  340. Fatal error: Call to undefined function pg_connect()
  341. Connection Exception
  342. joins
  343. How to know the Number of Connection made with the database
  344. how to write the select query for this situation
  345. C# .NET ===> postgreSQL
  346. Pagination in Postgre
  347. If criteria is Null then show all.
  348. Test Suite for Postgresql
  349. How can I display the stored image?
  350. Storing files in Postgresql database
  351. Interface to posgresql
  352. How to check a query execution plans in PostgreSQL
  353. HOW TO merge two strings
  354. need copy table sql example in postgres
  355. use of client-side \lo_import and \lo_export commands
  356. Server doesn't listen
  357. SHA function?
  358. Fastly Inserting Records
  359. how to release locks when instance crashes
  360. HOW TO Use transaction control statements inside a sored procedure
  361. Back Up And Restore
  362. Functions and Commits
  363. how to write this sql statement
  364. Nested use of found doesn't seem to be working
  365. Alter table doubt
  366. Driver for postgresql
  367. Redundant data in postgres
  368. Migrating data between dbs with different schemas
  369. Postgres Newbie - Case Problems in queries
  370. Multi dimensional arrays, sub selects...
  371. Error When creating the table
  372. String was not recognized as a Valid Date Time
  373. Postmaster is accepting TCP/IP connections error
  374. Data Migration From Excel to PostgreSQL
  375. date queries with portions of the date unknown
  376. How to Fix Corrupt Tables
  377. Unable to connect
  378. Postgresql Compression Across Network
  379. limit database size
  380. limit database size
  381. query and subquery in python
  382. retrieve column array values
  383. how to execute script from file within function
  384. retreive values from an array into column
  385. Can PostgreSQL initiate a message through a socket?
  386. how to insert image
  387. which is the best interface for postgresql
  388. unable to set 'Owner' column to different role
  389. username
  390. inserting values into array column
  391. Query regarding odbc connection ??
  392. how to give login in a table
  393. limitation of postgresql
  394. how can I fetch data from the database and display it in form of a editable html form
  395. ALIAS error
  396. postgis function
  397. FATAL ERROR on Solaris 10
  398. postgresql function
  399. invert an array
  400. postgresql installation fails on windows 2000
  401. accessing last element of an array
  402. How to cast varchar into timestamp in postgres
  403. How to make a copy of data in RAM ???
  404. update multiple cols in trigger
  405. How to make cross-database reference in Postgres
  406. nesting joins
  407. How to insert multiple sub columns inside a column ??
  408. on delete set null problem
  409. Databinding bool fields
  410. Increase the Cache Size
  411. Query regarding SQL commands ?
  412. how to make a Postgre DB setup on windows
  413. PL/PGSQL function
  414. getting the last record using timestamp
  415. create database test if not exists
  416. Writing DDLs in Functions
  417. Writing DDLs in Functions
  418. Postgre Sql on Solaris operating system
  419. urgent help!!
  420. Sum of “sales” for each date in a timestamp column
  421. How to know that a schema exist?
  422. Web Development Team Needed - Prefer Croatian or Eastern Europeanbased
  423. PHP Postgresql "All-In-One" CRUD Needed
  424. need help
  425. a problem when I create a trigger procedure.
  426. Postgres on XP / ODBC setup / Visual C++ API
  427. Transaction Logging Mechanism
  428. SQL question??
  429. TCP/IP Connection Error
  430. The MySQL command LEFT() counterpart in PostgreSQL?
  431. Exception Handling
  432. current transaction aborted
  433. SQL problem, help if possible please.
  434. How can I support multimedia with postgres?
  435. Postgres Connection Error
  436. HI all
  437. Restoring dump files completely
  438. PostgreSQL - JDBC2 lose connectivity after a while
  439. hi all
  440. .NET Questions
  441. postgresql module
  442. Copy / Paste in PostgreSQL from remote server.
  443. postgresql installation
  444. functions in postgresql!!!
  445. select distinct with datatype point
  446. an urgent question
  447. data conversion
  448. select-where anomaly
  449. Migration od Database
  450. installation error
  451. inserting values in relational main tables
  452. Hash index creation problem
  453. How can we manage PK and FK using inheritance??
  454. Are Primary Keys Necessary for Linking Tables?
  455. filename extension postgreSQL
  456. DBF to Postgres using DBF2PG
  457. Bulk Extract and Load data in PostgreSQL
  458. error in logs file
  459. To insert 60million rows to database
  460. can't get the full results from postgresql
  461. What is ODBC Query timeout error
  462. How to configure postgres for max disk space usage
  463. web interface library/classes
  464. Sql Case Statement
  465. Problem with executing Postgres function from javacode
  466. pg_clog errors
  467. table creation
  468. Postgres and ESQL
  469. Postgresql Vs. Mysql -- Need advice
  470. How to write postgres query with time comparison ?
  471. Hey i need advice!
  472. Subjectre31
  473. Reg Postgres Sql Replication Concept
  474. Reg Postgres Sql Database Instal On Windows 2000
  475. Syntax error doesn't make sense...
  476. just some info you might be intersted
  477. Tickets
  478. Create UNIQUE KEY
  479. Reg AutoVacuum
  480. Garbage Collection with Custom Session Handlers?
  481. Performance problem with joins
  482. plpgsql FOUND unexpected behaviour
  483. Need Clarification About Replication Concept In Postgres Sql
  484. How to convert from sql to postgresql (stored procedure)
  485. 7.4.13 LANG=C, order by still wrong
  486. Recieving notification when a table changes
  487. Limitation in query result from postgresql table
  488. date format in postgresql database
  489. libpqdll.lib
  490. Help with Database Solution
  491. Linking Tables from 2 databases
  492. Ora2PG exporter and UTF Characters
  493. alternative to distinct on?
  494. How to Use "If Exists" in PgSql
  495. Postgresql Stored procedures
  496. Postgresql
  497. Money datatype?
  498. Performance Issues PostgreSQL on Solaris
  499. Two general, simple questions
  500. Postmaster Problem
  501. What architecture for a Large Database with PostgreSQL
  502. XP Embedded and Postgres No Happy Campers
  503. Fedora Core 4 & PostgreSQL
  504. xml export tool?
  505. Dual servers
  506. Python x Postgresql Thrreading Problem
  507. Outer Join on 3 tables
  508. Conditional delete
  509. Timestamp not working
  510. is there a function which elminates spaces?
  511. OLAPy stuff crawling a bit
  512. async queries (libpq)
  513. Looks to me like MySQL has a change coming
  514. Generate/Manage a PostgresSQL database using Visio?
  515. PostgreSQL Linked server question with MSSQL2K
  516. Urgent: Input of values to execute dynamic queries
  517. 1991 and 1992 Black Box Catalogs
  518. Happy Fish Database Designer
  519. Need Database person
  520. Need Database person
  521. encoding question
  522. Where can I download HTML manual?
  523. linking access using ODBC driver with geometric data
  524. Good Portal for data mining resources
  525. Tablespace layout question
  526. scroll cursor bug or me?
  527. SQL Profiler
  528. How to copy a PG database
  529. ordering text field with non-alphanumerical character
  530. crosstab error 'query-specified return row and actual function return do not...
  531. Statement-level Triggers
  532. DateAdd function ?
  533. views, functions and parameters...
  534. ADO and PostgreSQL functions
  535. How to return a record and sets of record in plpython
  536. Great News Blog!
  537. Query Optimizer Failure / Possible Bug
  538. Bitwise operators for bytea
  539. can't update bytea field with function
  540. resultset to xml
  541. Tsearch index not set by UPDATE in PgSQL 7.3.2
  542. function no return
  543. Installing PostgreSQL 8 on Debian
  544. how to run function?
  545. SQLDescribecol in driver 8.00.0100
  546. Postgresql 8.0-beta2-dev3 on Windows 2000
  547. Adding pgAdminIII Server - Passwords?
  548. Good page with Oracle x PostgreSQL comparsion
  549. PostgreSQL and XML
  550. Danish users