Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql
Search options not deleted
user 81631
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
3
votes
When will autovacuum work in PostgreSQL?
PostgreSQL documentation
AUTOVACUUM is the standard form of VACUUM run automatically. If you insist on freeing unused space from tables, then do manual VACUUM FULL. …
- 284
2
votes
How to convert an age interval into a decimal year number in PostgreSQL
SELECT EXTRACT(EPOCH FROM INTERVAL '29 years 6 mons 22 days 21:17:52.860842')/31557600;
where 31557600 is roughly the number of seconds in a year.
- 284
1
vote
How to store a (record which holds a) reference to any other column (attribute) in another t...
Luckily, PostgreSQL has many noSQL features you can use.
Also, if number of attributes is not fixed, don't implement them as columns in one table, add one level of abstraction. …
- 284
1
vote
postgresql grant user privilages to dynamically created tables
Set your default privileges for the schema using ALTER DEFAULT PRIVILEGES
- 284
1
vote
Removing spaces from postgres SQL
As spaces can be freely used in SQL, maybe you have some non-printable characters in your code. This problem usually relates to using Windows and/or word processors for programming. How (using what pr …
- 284
1
vote
Should PostgreSQL be Installed on a Server Machine for Multi-User Access?
It can be installed to a server or you can buy it as a cloud service.
As your organization has an IT department, you should ask their opinion first.
- 284
1
vote
PostgreSQL efficient database structure
Your setup is a good option to do it. If you need more information about the stores (store name, street address, city etc), you could add table store with needed fields and have store_id in history ta …
- 284
0
votes
attach csv file on email sent from postgres
Since you've already picked perl the easiest way might be to use MIME::Lite
- 284
0
votes
0
votes
Load data into postgresql from file with trailing delimiter
Pre-process the file. A simple
perl -pe 's/(.*\|.*\|.*)(\|)$/$1/'
should do the trick.
- 284
0
votes
Unique global primary keys for multi region application
Use UUID keys, with region_id uuid DEFAULT uuid_generate_v4 () as your primary key.
- 284